Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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
8 - Asteroid

Solution attached

Highlighted
Alteryx Partner
Alteryx Partner

RegEx my friend :)

Highlighted
8 - 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
8 - Asteroid

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

Highlighted
7 - 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

 

 

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
10 - Fireball

Tricky one parsing this out

 

Spoiler
Challenge 20.PNG
Highlighted
8 - 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
8 - Asteroid

My Solution