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 Output1245 1245125466 12546615488NER 15488NER154896NIR 154896NIR1236564 1236564158 15814789 14789 Note: *=Annual All accts

I need help in customized filter.

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

Help

Accepted answers

binu_acs

@anonymous008_G

Raj

@anonymous008_G
REGEX_Match([Input],"^\d.*") use this formula.

All comments

binu_acs

@anonymous008_G

Raj

@anonymous008_G
REGEX_Match([Input],"^\d.*") use this formula.

anonymous008_G

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?

binu_acs

@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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703