Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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