SOLVED
REgEx Problem
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
MostafaBouzari
8 - Asteroid
‎03-09-2020
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi Everyone
I am trying to get first 4 digits with this
\[\d+
but it works sometimes and returns nulls
[06494-ghfgjfgj dfhdfh456-435-345-45-SUR] drhth rtz 67 (fgh 956005 zd)
[3495-GTHGH-GTJ-BLOO-RUS] SGHPin fn dtzh (RAL 456 MS)
[02942] transform
[02942]
and i'm using Regex tool(Parse)
in Regex101 Works but not in alteryx, pls give me some addvice how to check my Expression
Best Regards
Solved! Go to Solution.
2 REPLIES 2
markcurry
12 - Quasar
‎03-09-2020
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RegEx Parse should work, but you need ()'s around what you want to extract, so try .... \[(\d{4})
20 - Arcturus
‎03-09-2020
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you're looking for the first 4 digits, please try:
(\[\d{4}).*
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.
