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

bihitakdass 

Let me know if that works for you.

regexreplaceall("\d+k\s*(?:[$€]|CHF|EUR|USD)", PUT YOUR STRING HERE ," ")

Hi Shubham,
Thanks this worked to certain extent but can you also suggest something for 

1. Test 0.5M EUR Test :--> Test Test

2. Test 2121K€ test data :--> Test test data

3. Test 110EUR test data :--> Test test data

4. Test 7.95USD test data :--> Test test data 

This k can be in caps also like 211K and not just K, it can be Billion("b" ,"B") ,Million( "m" , "M") 

So can you help in modifying the regex to accept 

Hi Shubham,
Thanks this worked to certain extent but can you also suggest something for 

1. Test 0.5M EUR Test :--> Test Test

2. Test 2121K€ test data :--> Test test data

3. Test 110EUR test data :--> Test test data

4. Test 7.95USD test data :--> Test test data 

This k can be in caps also like 211K and not just K, it can be Billion("b" ,"B") ,Million( "m" , "M") 

So can you help in modifying the regex to accept 

The pipe character in RegEx acts as an "OR" operator - so you can extend the RegEx pattern accordingly:

regexreplaceall("\d+[k|K|m|M|b|B]\s*(?:[$€]|CHF|EUR|USD)", ri!data ," ")

bihitakdass  Let me know if that works for you

regexreplaceall(
  "\b\d+(\.\d+)?[kKmMbB]?\s*(?:[$€]|CHF|EUR|USD)\b",
  PUT YOUR STRING HERE,
  " "
)