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!
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!
@Kenda ,
It does!!
Thanks a lot!