Every 5 characters insert a new column

[BautistaC888]

Hello,

I need to parse data into a new column every 5 characters. For example:

Input:

0a4fs5re2s

7udsalsa35

Output:

0a4fs	5re2s
7udsa	lsa35

I think Text to columns can do it, but i'm stuck on the delimiter.
Thank you.

[Luke_C · Accepted solution]

@BautistaC888 

You could use regex to parse this:

(.{5})(.{5})

[apathetichell · Accepted solution]

Regex tool - parse mode:

(.{5})(.{5})

That will give you two columns of any 5 characters.

[messi007 · Accepted solution]

@BautistaC888,

Please see below:

Attached the workflow,

Hope this helps,

Regards