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

catarina_pimpao
8 - Asteroid
Spoiler
AWC_54.PNG
prislam
8 - Asteroid

 

 

Spoiler
challenge 54 pris.png

Had some trouble with this one but found a way in the end

Tom_Luthi
8 - Asteroid

solution attached

KatyP
7 - Meteor

I am new to regex and have, as ever, learnt from your provided solution! Thanks for these challenges.

AndrewLehm
8 - Asteroid
 
ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Not totally happy with this because I did the parsing by keyword: Street, Avenue, etc. Works for the sample provided but isn't the best solution.

Capture.PNG
sachin02
8 - Asteroid
 
ipeng
8 - Asteroid

My solution

sachin02
8 - Asteroid
 
EW
11 - Bolide

My solution:

 

Spoiler
I started with a list of street terms (Street, Avenue, DR) and did find and replace to add |s after them.  I suspect there's a way to get the RegEx tool to do most of the other steps itself (output null for missing zip codes, for one) but I added extra tools instead.

054EW.PNG