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