Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #20: List Parsing

Highlighted
Alteryx Partner

Here's my solution to challenge 20.
Finding a way to A) separate addresses from company names, and B) handle phone numbers with extensions was incredibly frustrating.

Highlighted
Asteroid

Solution attached

Highlighted
Quasar
Quasar

RegEx my friend :)

Highlighted
Asteroid

Wow this one was a real headache! Especially when I somehow messed up saving it and had to start from scratch just after I'd got the solution out. Good practice for Regex though. And I was chuffed that I did a better job of extracting phone numbers from the address field than in the given output :D

Highlighted
Asteroid

My solution attached. It's not the cleanest or the most efficient, but it works.

Highlighted
Meteor

This one was difficult but a nice challenge. A real test of Regex and some other formulas. All in all great practice!!

Spoiler

Marsh_Snip.PNG

 

 

Highlighted
Alteryx Partner
Spoiler
20. Data Parsing.PNG

Wasn't easy this one! Had to peek at the spoilers to see if the approach I was taking made sense, and then I finally got the regex working to catch all the exceptions

Highlighted
Fireball

Tricky one parsing this out

 

Spoiler
Challenge 20.PNG
Highlighted
Asteroid

Will be great to have a resource or a reference for RegEx expressions; I had to do a lot of research on this one. I used this page for the phone numbers http://phoneregex.com/

Highlighted
Asteroid

My Solution