Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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 #54: Data Prep Address Parsing

Highlighted
8 - Asteroid

Here is my solution

Highlighted
8 - Asteroid
 
Highlighted
6 - Meteoroid

Hi everyone. I share my solution. I thought this was a beginner challenge but it took me a while!

Idk if the resolution is good enough, but it solves the challenge.

I'm kinda in love with RegEx so I use it to capture Zip Code & State and then to look for some patterns like "Street", "Avenue", and so on, and capture the city. 

Spoiler
Capture.PNG

 

 

Highlighted
8 - Asteroid
 
Highlighted
Alteryx
Alteryx
 
Margarita Wilshire
Manager, Customer Support Engineering


Alteryx, Inc.
Highlighted
8 - Asteroid

I got it, but I don't like it.

 

Spoiler
solution_img_JTM.JPG
Highlighted
8 - Asteroid
Spoiler
KevinHarrison_0-1582745828937.png

 

I am not really happy with solution but it works.

Highlighted
7 - Meteor

Not knowing RegEX doesn't  help and don't like this solution but had to be done

Spoiler
LevL_1-1582807131180.png

 

Highlighted
Alteryx
Alteryx

I used a different approach Not the cleanest but it worked !

Highlighted
7 - Meteor

Solution attached.

 

Spoiler
eric_strein_0-1583099953417.png