Filtering out only numbers

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

Help

Accepted answers

alexnajm

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

malteryx1

You can try this using data Cleansing tool and Filter Tool. Attaching the screenshot for your reference. Screenshot (6).png

All comments

alexnajm

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.

Filter out numbers.yxmd

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

You can try this using data Cleansing tool and Filter Tool. Attaching the screenshot for your reference. Screenshot (6).png

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280