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

cindyrez
8 - Asteroid

Thanks for the practice - especially with RegEx.  I couldn't do this on my own, but still learned a lot.

johnyli168
Alteryx
Alteryx

My solution attached!

 

Spoiler
johnyli168_0-1627962109388.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 54.PNG
kcfuiks
8 - Asteroid

That was terrible. Here's the long way round solution.

ARussell34
8 - Asteroid

Here is my solution for 54!

AnnaG
8 - Asteroid

Solution attached

MUHAMMED_NABEEL_P
8 - Asteroid

City column is some what tricky..

Jotigautam
10 - Fireball

 

Spoiler
Not the best possible solution , but works in this scenario.. definitely CASS tools are better at this.
Jotigautam_1-1629463444286.png

 

psampaio005
8 - Asteroid

Pretty sure that is a better way to solve it but it is done.

Spoiler
psampaio005_0-1629847558676.png

 

MatthewBr
Alteryx Alumni (Retired)

a little but REGEX a little rock-n-roll.