SOLVED
Filtering out Alpha numeric data contains in a coloumn
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sekarsdream
8 - Asteroid
‎09-06-2017
11:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
andre347
10 - Fireball
‎09-07-2017
12:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
‎09-07-2017
01:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks a lot it helped