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.
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.
