Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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