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 |
Solved! Go to Solution.
Maybe RegEx_Match([Input],"\d+") ?
Thanks this is solved. Can you please explain what "\d+" does in the folrmula?
@anonymous008_G - another approach not using regex. Using cleanse tool to remove numbers, then filter out empty rows.
"\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!
You can try this using data Cleansing tool and Filter Tool. Attaching the screenshot for your reference.