Hi Team,
Can anyone please help me with regex to replace every number in string having following with space.
Example
1. Test 2121k$ test data :--> Test test data
2. Test 2121k€ test data :--> Test test data
3. Test 1000k CHF test data set :--> Test test data set
4. Test 1000k EUR test data set :--> Test test data set
5. Test 1000k USD test data set :--> Test test data set
Thanks
Bihitak
Discussion posts and replies are publicly visible
Not sure about your exact requirements. You can try the following if the prefix and postfix string are fixed:
left("Test 1000k USD test data set", 5) & right("Test 1000k USD test data set", 13)