Filtering values

[rajputakansha]

Hi,

I have a column with some letters(see below)

1210IO5342UF

435T459w34B56

78fg4669lZG6V672

Is there any way I can remove all the letters and get the following output?

12105342

4354593456

7846696672

Thanks for your help!

[Kenda · Accepted solution]

Hi @rajputakansha 

I would recommend using a Formula tool and using this expression: 

REGEX_Replace(REGEX_Replace([Field1], "\l", ""), "\u", "")

This basically looks for any uppercase or lowercase letters and replaces them with nothing. 

Hope this helps! 

[rajputakansha]

@Kenda ,

It does!!

Thanks a lot!

[TonyA]

Another option would be to use a Data Cleansing Tool with all options in "Remove Unwanted Characters" checked except "Numbers." Make sure to select only the column you want to process!