Cleaning the data

[Data_Alter]

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

[Luke_C · Accepted 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\.]+)

[Maskell_Rascal · Accepted solution]

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