Filtering out only numbers

[anonymous008_G]

Hi All,

I want to filter out only number string from below column. characters should get eliminated. How i can write custom formula to get this result. Can someone please help me here

Input
111
222
333
444
555
666
777
888
999
Bansi
Ashish
I love my country

[alexnajm · Accepted solution]

Maybe RegEx_Match([Input],"\d+") ?

[anonymous008_G]

Thanks this is solved. Can you please explain what "\d+" does in the folrmula?

[Bren_Spill2]

@anonymous008_G - another approach not using regex. Using cleanse tool to remove numbers, then filter out empty rows.

[alexnajm]

"\d+" is Regex syntax for "one or more digit characters" - by using the Regex Match function, I am basically saying there has to ONLY be digit characters. Everything else therefore should be filtered out!

[malteryx1 · Accepted solution]

You can try this using data Cleansing tool and Filter Tool. Attaching the screenshot for your reference.