Free Trial

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

OllieClarke
15 - Aurora
15 - Aurora

State and Zipcode were pretty straightforward, my City parsing felt a bit manual for my liking

Spoiler
challenge 54.PNG
coreyfrancom
7 - Meteor

I guess I need to figure out Regex.

Walsh67
8 - Asteroid

My solution...

justynam
8 - Asteroid

My solution

T_Willins
14 - Magnetar
14 - Magnetar

My solution.  Had to create table to find where city would be begin (after Circle, Street, etc.)

clcowell
6 - Meteoroid
 
JoBen
11 - Bolide

Cheers!

MarMu
8 - Asteroid

 

Puuh. That didn't felt like a beginner challenge. It took a while for me to figure out how to parse the city. The two other fields was pretty straight forward.

 

Spoiler
challenge_54_start_file_MarMu.png

 

Laurap1228
11 - Bolide
Spoiler
Spoiler
challenge54.jpg
Alconite
7 - Meteor