Hi there,
Can someone please guide me how would i filter out below sample data so that i can filter out unwanted data which starts with characters and blank cells.
Input | Expected Output | |
1245 | 1245 | |
125466 | 125466 | |
15488NER | 15488NER | |
154896NIR | 154896NIR | |
1236564 | 1236564 | |
158 | 158 | |
14789 | 14789 | |
Note: | ||
*=Annual | ||
All accts |
Solved! Go to Solution.
@anonymous008_G
REGEX_Match([Input],"^\d.*") use this formula.
Thank you for the solution both of you. I had used this formula RegEx_Match([Input],"\d+") but this was not filtering the records which has numeric and character i.e 15488NER, 154896NIR etc.
Can someone please help me to understand the difference between this two codes?
@anonymous008_G \d+ only consider numbers it will not consider any others characters that’s why you need to specify ^\d.+ , this regex pattern looks for any string start with a digit then any characters followed by the number will consider.
^\d means starts with a digit
.+ One or more characters