ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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

Tokenize in Regex tool.

BharathSrivatsa
7 - Meteor

Hey guys. So I have a doubt with using of Tokenize option in Regex. Here is the input and output 

20050808 to 2005  08  08 (space represents a new column, so basically 3 columns). And the numbers in the input tool are in String format.

Initially my regex was this: (\d{4})(\d{2})(\d{2})

But I realized later that we can use only 1 marked section and I don't want to use multiple regex tools. 

My doubt is how to write regex such that I can tokenize a string with no delimiters into different columns. 

Thank you. 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @BharathSrivatsa 

 

You are in the right path 😅 use parse mode

 

atcodedog05_0-1628861817774.png

 

Hope this helps : )

 

BharathSrivatsa
7 - Meteor

I was so fixated on Tokenize i forgot about other methods 😬😬😬😬

Thank you @atcodedog05 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @BharathSrivatsa 

Cheers and have a nice day!

Labels
Top Solution Authors