Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

DanielG
12 - Quasar

Solved.  Not scalable, but was able to get it done with 4 tools not including input or browse.  :)

RamaJ
7 - Meteor

My take on challenge 54

Carlithian
11 - Bolide
11 - Bolide

love the difference 4 and a half years make

 

down to a single regex

 

Spoiler
Carlithian_0-1671106383486.png

 

KathrynMW
8 - Asteroid

I couldn't work out how to parse the zip code out in the same RegEx tool so have used two.  I'm sure there is a way and maybe in the future I'll try again!  But here's my attempt at this challenge.

Spoiler
Challenge 54 Spoiler.JPG

lucascs
8 - Asteroid

solved

es7h3r
7 - Meteor
Spoiler
challenge 54.png
KORKIS3
8 - Asteroid
Spoiler
KORKIS3_0-1671735383292.png

 

simple solution : )

StanleyKinnok_Chan
8 - Asteroid

Mine is pretty effective IMO 

oliver_inthavong
8 - Asteroid

My solution:

Spoiler
Challenge 54 Spoiler.png
geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1672366949767.png