Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

gguedes1
8 - Asteroid

From the data set, I was able to parse the state( 2 initials), Zip ( 5 digits), and the city.

 

This did not feel like a beginner challenge to say the least.

cgoodman3
14 - Magnetar
14 - Magnetar
Spoiler
Getting more confident with regex
Challenge 54.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Suzu
9 - Comet

Here is my solution.

erick_irigoyen
Alteryx Alumni (Retired)

This one was tricky

MConidaris
7 - Meteor
 
RobertoEstrada
8 - Asteroid

RegEx tool is becoming my favorite.

dillon_bok
8 - Asteroid
Spoiler
Weekly Challenge - 54.PNG
JORGE4900
8 - Asteroid

I love working with the Regex tool; I could do this all day long. I was introduced to Regular Expressions many years ago while taking a JavaScript class in college; I ended up using regular expressions with PHP, CGI/Perl, Java and now Alteryx.

 

Spoiler
2019-06-18_12-58-40.jpg
garthn555
8 - Asteroid
Spoiler
gn_challenge_54.png

My rather crude version

wwatson
12 - Quasar
Spoiler
Got it using a regular expression statement