Challenge #54: Data Prep Address Parsing

[gguedes1]

From the data set, I was able to parse the state( 2 initials), Zip ( 5 digits), and the city.

This did not feel like a beginner challenge to say the least.

[cgoodman3]

Spoiler

Getting more confident with regex

[Suzu]

Here is my solution.

[erick_irigoyen]

This one was tricky

[RobertoEstrada]

RegEx tool is becoming my favorite.

[dillon_bok]

Spoiler

[JORGE4900]

I love working with the Regex tool; I could do this all day long. I was introduced to Regular Expressions many years ago while taking a JavaScript class in college; I ended up using regular expressions with PHP, CGI/Perl, Java and now Alteryx.

Spoiler

[garthn555]

Spoiler

My rather crude version

[wwatson]

Spoiler

Got it using a regular expression statement