Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Every 5 characters insert a new column

BautistaC888
8 - Asteroid

Hello,

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

 

Input:

0a4fs5re2s
7udsalsa35

 

Output:

0a4fs5re2s
7udsalsa35

 

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

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

@BautistaC888 

 

You could use regex to parse this:

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

 

Luke_C_1-1616516276882.png

 

apathetichell
19 - Altair

Regex tool - parse mode:

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

 

That will give you two columns of any 5 characters.

messi007
15 - Aurora
15 - Aurora

@BautistaC888,

 

Please see below:

 

messi007_0-1616516435177.png

 

Attached the workflow,

Hope this helps,

 

Regards

Labels
Top Solution Authors