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

sharathkumargurram1
7 - Meteor

Hi ,

 

Nice one helped me explore RegEx Cheers!!!

 

Best Regards,

Sharath Kumar Gurram.

CobusVenter
7 - Meteor

Here's mine:

Verakso
11 - Bolide

Took me a while to get it started right, and I still had some issues with my regex, but in the end I did get the desired result.

 

All though I am still quite impressed by the approach by @mceleavey 🙌

 

Spoiler
Mt WorkflowMt WorkflowAs mentioned it took me a while to figure out, how to make the first split of the addreses, but by poking arround I could see a trend, than I tried as well.

 

Still Climbing

/Thomas

Sajeel_Kershi
8 - Asteroid

completed

rfergus
8 - Asteroid
Spoiler
image.png
Jonathan-Sherman
15 - Aurora
15 - Aurora

I've attached my solution!

cplewis90
13 - Pulsar
13 - Pulsar

Don't think this solution is very creative as it seems to be similar to a few other solutions.

Spoiler
Challenge 54.PNG
Deevi
8 - Asteroid
Spoiler
challenge_54_Data Prep Address Parsing.png
JonathanAllenby
8 - Asteroid

Here's my (not at all optimal) solution to challenge 54.

TonyA
Alteryx Alumni (Retired)

Tried playing with a few different tools but eventually settled on using regex for the parsing -- I need all the practice with that tool that I can get! I did manage to get it down to one regex to do the job.

Spoiler
2019-03-02_23-19-40.png