We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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