Solved! Go to Solution.
So the REGEX_REPLACE is saying "From the Test field, give me everything (.*) until you find something that's not ASCII (?:[^x20-x7E]) and then give me everything else (.*) and put part one $1 and part two $2 together into a new field".
For some reason, the (tm) seems to leave an extra space between the words, so I included a REPLACE that changes two spaces into one.
The above expression isn't working for me. Here is my input - nbn™ 12 and I am expecting to get nbn 12. It's not happening. I am not sure if I should be replying here or opening a new thread.
Two backslashes are missing in the formula: [^x20-x7E] should be replaced by [^\x20-\x7E]