Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #54: Data Prep Address Parsing

Highlighted
8 - Asteroid

My Solution - fairly straight-forward

Highlighted
13 - Pulsar

Regex again

Spoiler
en54.PNG
Highlighted
7 - Meteor

___________

Highlighted
8 - Asteroid

Creating the replacement table to enable parsing was a bit of a fiddle. Need to do more of this 

Highlighted
8 - Asteroid

Siobhan_Purcell_0-1599170508822.png

 

Highlighted
Alteryx Partner

Hi everyone!

 

It was fun to experiment with regex for this challenge!

 

Here is my solution:

 

Spoiler
challenge_54_completed.png
Highlighted
7 - Meteor

Thanks.

Highlighted
Alteryx Partner

Screenshot (6).png

 

Highlighted
8 - Asteroid

I would love to see how this task is performed on larger, dirtier data sets. I used the regex_replace function to replace the street name with pipe and followed up with a series of other formulas to extract the data of interest.

Highlighted
8 - Asteroid

Nice Task. Worked with a whitelist and Append Tool.