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

kaianderson
8 - Asteroid

Here's my solution!

ydmuley
12 - Quasar
12 - Quasar

Address parsing can be challenging at times unless we learn the RegEx properly. I tried my hands on this challenge with some basic RegEx formulas.

 

 

The solving thrill continues!!!!!!!!!!!!!!!!

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Ashley2
8 - Asteroid

Challenge 54 Complete!
My Solution;

Spoiler
Ashley2_0-1586260711339.png

 

tammybrown_tds
8 - Asteroid

My solution.  I didn't use the Regex to split the data, but I still arrived at the answer.  Also, if this was in real life, obviously, the text inputs would have to include every kind of street suffix and every state abbreviation.  But this works for this challenge.

 

Spoiler
Challenge 054.PNG
cneivam
9 - Comet

WOW!

cneivam
9 - Comet

Hello, follow attached my solution.

Regards,

Neivam

cneivam
9 - Comet

Hello, follow attached my solution.

Regards,

Neivam

Anood
7 - Meteor

Solution Attached 

Ben_Jeffreys
8 - Asteroid

My submission

deepaprash
8 - Asteroid

That was interesting.