Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Break a word in rows

Jean-Balteryx
16 - Nebula
16 - Nebula

Hello everybody !

 

I'm looking to break a word in rows, one letter per row.

 

Example :

 

1Word
2Joy
3Herb

 

This would become :

 

1W
1o
1r
1d
2J
2o
2y
3H
3e
3r
3b

 

I can't do it using the Text to Column tool as I have to specify a delimiter.

 

Do you have any idea ?

 

Thanks for your answers.

 

Jean-Baptiste

5 REPLIES 5
RishiK
Alteryx
Alteryx

@Jean-Balteryx 

 

Have a look at the attached sample workflow.

JoeS
Alteryx
Alteryx

Nice work @RishiK 

 

You could also use a full stop/period. This in regex means any character, so will split not only your letter A-Z but spaces and numbers too

Jean-Balteryx
16 - Nebula
16 - Nebula

@RishiK Thank you very much ! 

 

 

Jean-Balteryx
16 - Nebula
16 - Nebula

@JoeS Thank you for your advice !

mattnason
5 - Atom
Spoiler

 

Labels