Regex to replace any value having special character in string like 2121k$ , 2121k€, 1000k CHF, 1000k EUR, 1000k USD

There may be a more elegant way but it's easiest to understand and implement as two expressions:

1. an expression that takes as its input the data you want processed and performs a fn!reduce() on it, using the list of currencies you want to find and replace with the space character
2. a helper expression rule which is called by the above rule, which is called recursively by the fn!reduce() for each currency you want replaced. This uses the fn!regexreplaceall which uses a pattern to match on the string being and replaces all matches with, in this example, a space

The first rule looks something like this:

fn!reduce(
  rule!SJB_ER_replaceCurrencyValue,
  ri!data,
  { "\$", "€", "CHF", "EUR", "USD" }
  /* note that the dollar symbol in the list above includes the backslash escape character as */
  /* the dollar symbol has a speical menaing in regex expressions */
)

and the second rule looks like this:

fn!regexreplaceall(
  concat("[0-9]*k", ri!currency),
  ri!data,
  " "
)

If you need any further explanation as to what's happening here please ask.

There may be a more elegant way but it's easiest to understand and implement as two expressions:

1. an expression that takes as its input the data you want processed and performs a fn!reduce() on it, using the list of currencies you want to find and replace with the space character
2. a helper expression rule which is called by the above rule, which is called recursively by the fn!reduce() for each currency you want replaced. This uses the fn!regexreplaceall which uses a pattern to match on the string being and replaces all matches with, in this example, a space

The first rule looks something like this:

fn!reduce(
  rule!SJB_ER_replaceCurrencyValue,
  ri!data,
  { "\$", "€", "CHF", "EUR", "USD" }
  /* note that the dollar symbol in the list above includes the backslash escape character as */
  /* the dollar symbol has a speical menaing in regex expressions */
)

and the second rule looks like this:

fn!regexreplaceall(
  concat("[0-9]*k", ri!currency),
  ri!data,
  " "
)

If you need any further explanation as to what's happening here please ask.