In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Regex Expression

dillonrispoli
5 - Atom

I need to extract the "Prod CAT/ID" characters along with the information listed for each state. Any ideas given the data is all in column A? I think Regex could be helpful here, however, I am not too familiar with the syntax.

3 REPLIES 3
geraldo
13 - Pulsar

@dillonrispoli 

 

An example de regex

regex.JPG

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @dillonrispoli ,

Here is one way of doing this. I hope this helps.

 

Output

You can rename the column as you like.

PageNoProdCatIDCol1Col2Col3Col4Col5Col6Col7Col8Col9Col10Col11Col12
10056-200-ESC011AL ALABAMAN(D)N(D)N(D)N(D)****07/26/201807/26/2018
10056-200-ESC012AK ALASKAN(D)N(D)N(D)N(D)****07/26/201807/26/2018
10056-200-ESC013AZ ARIZONAN(D)N(D)N(D)N(D)****07/26/201807/26/2018
10056-200-ESC015CA CALIFORNIAN(D)N(D)N(D)N(D)****07/26/201807/26/2018
10056-200-ESC016CO COLORADON(D)N(D)N(D)N(D)****07/26/201807/26/2018
dillonrispoli
5 - Atom

Very helpful, thank you!

Labels
Top Solution Authors