Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
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

SGolnik
11 - Bolide
11 - Bolide

I chose this one specifically to practice my regex. I didn't get the zip code the same way, but still arrived at the same result.

ggruccio
ACE Emeritus
ACE Emeritus

Parsed it a ton!

LandonG
8 - Asteroid

Solution attached.

PhilipMannering
16 - Nebula
16 - Nebula

Here's my solution. The regex is necessarily clumsy to parse out the street name.

 

Spoiler
challenge_54 - Snip.PNG
jasperlch
12 - Quasar

Solution attached.

paul_houghton
12 - Quasar

Got myself tied up on how to identify the street dynamically, in the end just did it manually.

 

Spoiler
Challenge 54.jpg
blairmbailey
8 - Asteroid

Solution attached - thank you!

Suzanne
7 - Meteor

this solution isn't the most efficient but it works -:)

msicak
8 - Asteroid

if I can have a late Christmas present I want Regex skillz. The solution works but is by no means as flexible as some of the others here.

 

Spoiler
challenge54.png
BrendaS
8 - Asteroid

I didn't like the manual entry portion, but I couldn't figure out any good way around it.