SOLVED
RegEx formula to find a specific pattern
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
soncoku
9 - Comet
‎11-10-2020
07:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey all.
I have a column of data from which I want to pull out only this pattern:
293847463_323847565_1
So 9numbers_9numbers_1number
but I'm not that fluent in regex
any help would be appreciated 🙂
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
5 REPLIES 5
22 - Nova
‎11-10-2020
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Amarendra
10 - Fireball
‎11-10-2020
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @soncoku
@atcodedog05Solution works great!! To further help you, look at the lesson notes section in this article - https://regexone.com/ I hope this makes RegEx easy and fun for you!
20 - Arcturus
‎11-10-2020
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Answer should be:
Regex_Match([your data],"\d{9}_\d{9}_\d")
true or false as a Boolean variable in your formula or filter.
cheers,
mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
22 - Nova
‎11-10-2020
08:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-10-2020
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow. Thank you.
Much appreciated 🙂
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)