Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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

kaianderson
Astéroïde

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
Astéroïde

Challenge 54 Complete!
My Solution;

Révélation
Ashley2_0-1586260711339.png

 

tammybrown_tds
Comète

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.

 

Révélation
Challenge 054.PNG
cneivam
Comète

WOW!

cneivam
Comète

Hello, follow attached my solution.

Regards,

Neivam

cneivam
Comète

Hello, follow attached my solution.

Regards,

Neivam

Anood
Météore

Solution Attached 

Ben_Jeffreys
Astéroïde

My submission

deepaprash
Astéroïde

That was interesting.