ttc or regex

[utsarunner981]

hello everyone i am probably having a mental block but can someone recommend the best way to split a string into specific columns? the string is nonspecific-it changes from 9 characters to 15 

for example: 

this is my data 

column A

ABCDEFGHIJKL

ABCDEFGHI

this is the output i am wanting : 

column A      column B    column C

ABC                DEF           GHIJKL

ABC                DEF            GHI 

[atcodedog05 · Accepted solution]

Hi @utsarunner981 

I would suggest regex parse mode.

(\w{3})(\w{3})(.+)

Here is how you can do it.

Workflow:

Hope this helps : )

[utsarunner981]

@atcodedog05  yup! that worked! solved!

[atcodedog05]

Happy to help : ) @utsarunner981 

Cheers and have a nice day!