I need help in customized filter.

[anonymous008_G]

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

[binu_acs · Accepted solution]

@anonymous008_G 

[Raj · Accepted solution]

@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