Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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