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

Pang_Hee_Choy
12 - Quasar

solution

apathetichell
18 - Pollux

I'm sure there was a much easier way than 3 Regex tools but I can use the experience...

thaodinh95
8 - Asteroid

Here is my solution! Since I don't have address parse tool, I used string formula and RegEx and text input (Street, Avenue,...) to separate street and city.

rcarog
8 - Asteroid

Solution attached.

garrettlem1017
8 - Asteroid

Solution has been attached.

JP_SDAK
8 - Asteroid

I love RegEX!  This would have used only 2 tools if I weren't trying to use EQ to match nulls 😁

Spoiler
JP_SDAK_0-1614579222859.png

 

lkclooney
7 - Meteor

lkclooney_0-1614660323262.png

 

Luke_C
17 - Castor
Spoiler
Spoiler
Challenge054.PNG

vPir
7 - Meteor

This is my contribution.

jdbartosh
8 - Asteroid

Solution Uploaded