Alteryx Designer Desktop Discussions

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

String Parsing

Kanderson
10 - Fireball

I am a little stuck with a string parsing workflow. I am trying to parse a string from right to left in groups of 10. The Regex tool seems to work fine but I can only get it to work when I parse from left to right. The strings are not all the same length and they may not be divisable by 10. 

 

 

Essentially if we were parsing the alphabet I would like the get:

 

ABCDEF

GHIJKLMNOP

QRSTUVWXYZ

 

Is there a way in Alteryx to easily accomplish this?

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

If you are good with left to right, then you can REVERSESTRING([FieldName]) and then when you are done, reverse it back.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Kanderson
10 - Fireball

Cannot believe I overlooked that, works perfect, thank you.

Labels