Every 5 characters insert a new column

Question

Hello,

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

Input:

0a4fs5re2s7udsalsa35

Output:

0a4fs5re2s7udsalsa35

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

Luke_C · Accepted Answer

@BautistaC888

You could use regex to parse this:

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

apathetichell · Accepted Answer

Regex tool - parse mode:

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

That will give you two columns of any 5 characters.

messi007 · Accepted Answer

@BautistaC888,

Please see below:

Attached the workflow,

Hope this helps,

Regards