Filtering out Alpha numeric data contains in a coloumn

[sekarsdream]

Hello All,

trying to filter alpha numeric  data like AB1234567 and ab-1234567 (here number 1234567 can be any number between 0-9 but the Alphabets remains the same) , it may be in the start of the data or at the end of the row or anywhere in middle.But if its is available anywhere in the line i should filter it out any specific command  for this ?? i used regex match but it works only when at the start of the line , so please help me in this 

Regards

~Rajasekar

[andre347 · Accepted solution]

You can use the parse option in the regex tool to 'parse' out the digits. See the attached image.

Is that what you're after?

[sekarsdream]

thanks a lot it helped