community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #54: Data Prep Address Parsing

Meteor

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.

Asteroid
Spoiler
Getting more confident with regex
Challenge 54.PNG
Alteryx Certified Partner

Here is my solution.

This one was tricky

Meteoroid
 
Asteroid

RegEx tool is becoming my favorite.

Asteroid
Spoiler
Weekly Challenge - 54.PNG
Highlighted
Asteroid

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
2019-06-18_12-58-40.jpg
Asteroid
Spoiler
gn_challenge_54.png

My rather crude version

Asteroid
Spoiler
Got it using a regular expression statement