We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

caltang
17 - Castor

Done! Used Regex as well:

 

Spoiler
Screenshot 2023-07-02 092753.png


For anyone curious: ^(.*?)\s*~\s*(.*?)\s*([A-Z]{2})(?:\s*(\d{5}))?$

mithily
8 - Asteroid
Spoiler
Spoiler flex the regex
CVCurcurato
8 - Asteroid

An almost exlusively RegEx solution from me

dj-khaled-another-one.gif

 

rachel_lynch
Alteryx
Alteryx
Spoiler
Data Prep Address Parsing.png

Rachel Lynch
Sebastian_Chaieb2
8 - Asteroid

With bigger dataset (and more cases or roads, circles, streets, etc) it would be better to use lookup table instead Formula with Replace functions

Spoiler
Capture.PNG

Amy_smart
10 - Fireball

Here is my solution.

josedlr00
8 - Asteroid

Nice Challenge

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Speed

Dani_Lin
8 - Asteroid

solved

AndreeaS
8 - Asteroid
Spoiler
54.png