Alteryx Designer Desktop Discussions

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

Regex / Parse Assistance

kgordish
8 - Asteroid

Hello, 

I am not a regex expert. Need some assistance to help extract a specific letter-number string from free text. 

The format always follow three letters of RQT "-" 6 digits "-" 6 digits.


Originally tried to extract only the numbers, them use tokenize to separate to different rows and then trim. This is not an option because I noticed some dates within the data set and I did not want to keep the dates. 

 

Sample data: 

Free Text. Free Text.

RQT-000000-000000

Free Text. Free Text.

RQT-000001-000001

RQT-101000-100100

Free Text

 

Desired outcome:
RQT-000000-000000

RQT-000001-000001

RQT-101000-100100

 

or 

RQT-000000-000000, RQT-000001-000001, RQT-101000-100100 

Then I can simply separate by using a delimiter. 

 

Thanks in advance and helping to level me up.

Kevin

 

4 REPLIES 4
binuacs
20 - Arcturus

@kgordish Looking for something like below

 

binuacs_0-1673377617257.png

 

kgordish
8 - Asteroid

@binuacs 

 

Hi  Thanks for trying to assist. Sorry if  I am was unclear due to pictorial depiction.

Data Input is one row of data separated by split lines. Then a second row of Excel Data.

 

 Data Example.JPG

binuacs
20 - Arcturus

@kgordish Attaching the updated workflow

 

binuacs_0-1673378733825.png

 

kgordish
8 - Asteroid

@binuacs 

That worked. Thank you. 

The formula in regex is now understandable to me and not like reading a foreign language now. 

Labels