Challenge #54: Data Prep Address Parsing

[121Brain-]

Challenge completed.

[Alekh]

My solution

Spoiler

[Gauthier_B]

Regex only

Spoiler

[AntonioGonzales]

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/

An explanation of my regex can be seen below:

Spoiler

Nice exercise!

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

[AntonioGonzales]

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]

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

Regex makes me happy.

M.

[Avinash_K]

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

[cadyb]

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

[Steven_Pocoroba2]

Address parsing always fun and challenging

Thanks!