Reg Ex or Parsing a field

[ROHANPACH]

Hello experts

I have a data in which I want to parse data in the field. The data is unstructured and the idea to have the data in different columns / fields.

The 1st 6 digit number is account and consistent across the field

The 2nd 4 digit number is company code (AUSA, AITA) and consistent across the field

then we have 2 digit code (32,51 etc) which is not consistent - some fields we have it in other we have in different place 

last 2 digits also consistent

Please help

Rohan

[Jean-Balteryx]

Hi @ROHANPACH ,

What about ITA.. or TS.. codes ?

[atcodedog05]

Hi @ROHANPACH 

Can you provide an expected output so that we can work towards it.

[ROHANPACH]

Hi @Jean-Balteryx not really required for now, but we have that separately in a field, all the more better!

[Jean-Balteryx · Accepted solution]

I've built this workflow using regex and formulas as some information can be at two places.

Not sure it covers all cases. Tell me if it's okay or not !

[ROHANPACH]

It works! Thanks a lot! @Jean-Balteryx 

[atcodedog05]

Nicely done @Jean-Balteryx 🙂👍

[Jean-Balteryx]

You are welcome @ROHANPACH ! 🙂

Thank you @atcodedog05  ! 🙂