In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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

Challenge #20: List Parsing

StellaBon
11 - Bolide
Spoiler
RegEx, YIKES!RegEx, YIKES!

I mean, I did my best. If you're looking for a lot of Regex practice, this is your one-stop shop.

caltang
17 - Castor
17 - Castor

Complex but I think I got it.

 

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
DanielG
12 - Quasar

This was a rough one.

 

Solved.

 

rzdodson
12 - Quasar
Spoiler
SPOILER
danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-09-18 100345.png
Tgigs
8 - Asteroid

My solution attached.

 

Wow that took a while! Took some trial and error to write the regex to handle all the cases. Not the most dynamic solution but it gets the job done effectively. Hard to think of a way to solve this problem dynamically when there are so many inconsistent formats.

 

Essentially, I used regex to return a true/false to determine if the line is company, address, phone, fax, notes, or website. From there I was able to easily find a way to manipulate the data to get it in the appropriate format.

Tgigs
8 - Asteroid

Took me a while as well. Was a good exercise though

Dani_Lin
8 - Asteroid

solved

Computernerd
8 - Asteroid

I thought I had it, then the results were slightly off. I hadn't accounted for 1- Numbers. This one was tough.

JBLove
10 - Fireball

Solution Attached.