Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #54: Data Prep Address Parsing

fimler
8 - Asteroid

My Solution - fairly straight-forward

Qiu
21 - Polaris
21 - Polaris

Regex again

Spoiler
en54.PNG
Owaisf
7 - Meteor

___________

BobHabbijam
8 - Asteroid

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

Siobhan_Purcell
8 - Asteroid

Siobhan_Purcell_0-1599170508822.png

 

p_padham
8 - Asteroid

Hi everyone!

 

It was fun to experiment with regex for this challenge!

 

Here is my solution:

 

Spoiler
challenge_54_completed.png
Jayfay
7 - Meteor

Thanks.

alishadhillon__
8 - Asteroid

Screenshot (6).png

 

david14
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.

Christoph_Ebersbach
8 - Asteroid

Nice Task. Worked with a whitelist and Append Tool.