Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

REgEx Problem

MostafaBouzari
8 - Asteroid

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

 

 

2 REPLIES 2
markcurry
12 - Quasar

RegEx Parse should work, but you need ()'s around what you want to extract, so try .... \[(\d{4})

MarqueeCrew
20 - Arcturus
20 - Arcturus

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.
Labels