Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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

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