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

aiahwieder
8 - Asteroid

Got my Regex working on the first try! 🎉

Hub119
8 - Asteroid

Solution attached.

CRowlatt
8 - Asteroid

Not easy!

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1617442240086.png

 

AlexPeacock
8 - Asteroid

My Solution

 

lucia_haswell
7 - Meteor

My Solution:

mdsalmankhan89
8 - Asteroid

here is my solution ! 

soroosj
8 - Asteroid

Fun challenge to practice regex, particularly the "()" as the marking group.  I also tried the Find/Replace tool for first time, which helped normalize the street suffixes.

 

Spoiler
Capture.PNG
DataHabanero
9 - Comet

Ready!

Shifty
12 - Quasar

I've impressed myself with this one as someone who doesn't really know RegEx. 

 

I highly recommend the RegEx class within the Parsing Data Interactive Lessons (https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...) if you need a hand getting started with this stuff.

 

Spoiler
Shifty_1-1620656873670.png