Search

Close

Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Did it two ways with columns and rows of data but I am sure there is a way to just use regex to do it.

First time using the Tokenize method of the Regex Tool. Always love a challenge that makes me try something new!

First time using the Tokenize method of the Regex Tool. Always love a challenge that makes me try something new!

With every challenge I become better and better with the RegEx tool :-)

Done!

Post with solution file

Good Challenge

Done...

Done!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/

Solved

Pretty straight forward regex_replace formulas and text to columns approach. I was maxed out on Regex working on Challenge 20 recently so I tried to minimize my use of it here. 😂

Screenshot 2023-09-18 115028.png