Dear members,
I have some data in a row which is like this
||'04. Xyzabc xyzabc$'
I want it to look like this
04. Xyzabc xyzabc
I think this should be possible through regex but I am not able to make it work. Please can someone help
Solved! Go to Solution.
Hi @Data_Alter
See below/attached. I'm sure others might have a more elegant solution, but this seems to get the job done.
([A-Z_0-9_\s\.]+)
Hi @Data_Alter
This regex code should work for you. You can use this in a formula tool to cleanse the field in question.
REGEX_Replace([Field1], '[^\w\s\.]', '')
Cheers!
Phil