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.

Challenge #54: Data Prep Address Parsing

Asteroid

My solution

Alteryx
Alteryx

Not an easy challenge!

 

My solution:

Spoiler
Capture4.PNG
My download tool takes a list of common street abbreviations from the USPS website (https://pe.usps.com/text/pub28/28apc_002.htm), finds the position of the street address, then works backwards using the trim function to pull ZIP (if appended), then State, then City.

 

Highlighted
Asteroid

Hi! Here my solution :) (not very proud of it this time; I wrote a regex that worked well in an online simulator, but it didn't in the Regex tool)

Alteryx Certified Partner

My solution - really ugly ... I should finally start learning RegEx 

Alteryx Partner

My solution ..

Asteroid

Solved

Asteroid

 

Spoiler
Nothing too fancy
workflow.JPG

 

 

Asteroid

2019-01-24 (1).png

Asteroid

My Solution

Spoiler
Challenge 54 Spoiler.PNG
Asteroid

My solution: