Filter if first 6 characters are digits
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to solve an issue in my data. What i want to do is filter down one pathway if the first 6 digits are numbers and if false to go down a different pathway. I have all the downstream logic figured out, but just need to figure how to filter my data. I have included a sample below:
436717 Don Trim-MacDonald demob to NS |
361055 Wilfred Hayman modules |
519079 JASON BAUMLE |
610233 Kevin Hoeg |
557641 JEREMY ROBBINS |
519079 JASON BAUMLE OFF SITE WORK |
409073 - ALEXANDER BAGNYUK |
409073-ALEXANDER BAGNYUK |
409073-ALEXANDER BAGNYUK-TRAVEL |
TRAVEL |
595351-CHARLES TILLEY |
566958 - Bowen Evans |
TECHNICIAN,NDT,GENERAL FOREMAN |
So i was thinking of a filter tool with a contains, but i couldn't get it to work. Note that the numbers are always the the beginning and would have to only be if there are 6 digits.
Thoughts?
Thanks!
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @krishnagandhi,
The filter tool will work you just need to use the following formula.
REGEX_MATCH(LEFT([Your Field Name],6), "[0-9]*")
See Attached.
Best,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
for readability, simplicity and performance:
IsNumber(Left([text field], 6))
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if you really wanted a regex expression that you don't completely understand,
Regex_Match([your field],"\d{6}.*")
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
