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!
Solved! Go to Solution.
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!
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!