Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Regex Paring ( Character & number)

Tommy23
7 - Meteor

Hello,

 

I would like to know if there is a way using regex tool to do this following:

 

I have rows  who look like this ( Example) : 

2432D1234GS111

2544D6573GI177

2562A0A00GS174

2455L1234GI145

 

I would like to have this split in three colunm this way :

Colounm 1     Colunm 2  Colunm 3

2432             D1234         GS111

2544             D6573         GI177

2562             A0A00         GS174

2455             L1234          GI145

 

What would be the regex expression inside the Regex tool ( parse) ? ( I have the more 

trouble with the A0A00

 

Thanks in advance for you help,

Best regards,

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @Tommy23 I mocked up a workflow let me know what you think?

echuong1
Alteryx Alumni (Retired)

Try the attached.

 

I did one based on 4 digits and then a letter followed by 4 digits and a letter followed by 4 digits. The top one is based purely on character count.

 

echuong1_0-1605553182024.png

 

Labels