In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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

cameronfraser
7 - Meteor

A couple of RegEx solutions:

 

Spoiler
cameronfraser_0-1672443778991.png

 

lhalliwell
8 - Asteroid
Spoiler
Screenshot 2023-01-06 095039.jpg

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1673257277217.png

 

patrickprentice
8 - Asteroid

Harder than I expected.  I really need to learn my RegEx.  Solution:

NicolasSz
11 - Bolide

Only one component needed : The Regex parser. Rest is the magic :P 

 

 

Spoiler
could be improved to be more robust / not case sensitive etc


(?:Circle|Street|Drive|Ave|Road|St|Avenue) (.*) ([A-Z][A-Z]) ?(\d\d\d\d\d)?$
lucysinclair62
8 - Asteroid

Too many regex

Spoiler
lucysinclair62_0-1674057758951.png

 

danblythe
8 - Asteroid
Spoiler
Nice and quick
eraaz_lala
8 - Asteroid

Hello,

Please find my solution to Challenge #54

 

Regards, Eraaz

alacoume
9 - Comet

My solution:

sherinamahtani
7 - Meteor

Love a bit of RegEx