In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors