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

hayley9
8 - Asteroid

Here is my solution

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

 

 

AryCardoso
8 - Asteroid
 
MargaritaW
Alteryx Alumni (Retired)
 
Margarita Wilshire
Sr. Manager, Customer Support Engineering
Women & Allies Committee


Alteryx, Inc.
jtwmoore
8 - Asteroid

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

 

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

 

I am not really happy with solution but it works.

LevL
7 - Meteor

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

Spoiler
LevL_1-1582807131180.png

 

ChiN
Alteryx Alumni (Retired)

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

eric_strein
8 - Asteroid

Solution attached.

 

Spoiler
eric_strein_0-1583099953417.png