We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

lwolfie
10 - Fireball

Fun exercise.

myahya
7 - Meteor
Spoiler
image.png
dkungu
8 - Asteroid

There is never enough regex practice

Aleksandar1
7 - Meteor

Here is my solution

Tgigs
8 - Asteroid

My solution attached.

 

Not my greatest work

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-11-14 175400.png

RasmusFormo
8 - Asteroid
Spoiler
54.png
Rob-Silk
8 - Asteroid

My solution below:

Spoiler
I tried to solve it two ways, once using a text input with the different "end-of-street-address" possibilities used to mark the transition from the street address to the city, and then second using a single RegEx Parse tool (including this logic within the parsing). I would say that although second solution looks nice because it uses a single parse tool to complete, potentially it would be nicer to maintain a single text input list if any new "end-of-street-address" words/characters were found when used on a real or different dataset.

challenge_54_RS_screencap.PNG
jennifer_owens
8 - Asteroid

I can never seem to get Regex to output exactly what I want in one pass. I look forward to reviewing other user's solutions! 

 

SanjeevDosanjh
7 - Meteor
Spoiler
Screenshot 2024-01-10 120410.png