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

121Brain-
7 - Meteor

Challenge completed.

Alekh
9 - Comet

My solution

Spoiler
54..png

 

 

Gauthier_B
8 - Asteroid

Regex only

 

Spoiler
Challenge 54 Screen.PNG
AntonioGonzales
8 - Asteroid

Solved using regex tool with parse output mode.

 

I learned a lot of things with this exercise, in particular, I utilized a site that I had heard before in one of Alteryx live training to test our regex dynamically:

http://rubular.com/

rubular.png

 

An explanation of my regex can be seen below:

 

 

Spoiler
regex_54.png

Nice exercise!

Let's have a look at my friends' solutions! :-)

 

AntonioGonzales
8 - Asteroid

Dear @mceleavey,

 

Hope you are very well.

 

I just want to thank you a lot for this workflow!

 

My mind is bubbling with it. :-)

 

I got a Google API key (my first time using Google APIs) and I'm testing your workflow and finally, I am starting to understand when I have to use '?' in my regex.

 

In other words, I started understanding what is the difference between long.*?] and long.*]

 

Thank you so much for share your ideas here.

Cheers

mceleavey
17 - Castor
17 - Castor

Fantastic! I'm so glad I could help, and thanks for the feedback. 

 

Regex makes me happy.

 

M.



Bulien

Avinash_K
8 - Asteroid

Started doing the weekly challenges recently , and found this exercise very useful to learn a bit of regex

cadyb
Alteryx
Alteryx

Use one Regex tool to look for Circle, Street, etc. Took a bi of playing with to get it to work right!

bradley_slaughter
8 - Asteroid
 
Steven_Pocoroba2
8 - Asteroid

Address parsing always fun and challenging

 

Thanks!