Regex Paring ( Character & number)

[Tommy23]

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,

[JosephSerpis · Accepted solution]

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

[echuong1 · Accepted solution]

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.