Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #20: List Parsing

WernerE
8 - Asteroid
Spoiler
Screenshot_1.jpg
DN
8 - Asteroid
Spoiler
Capture.PNG

bkclaw113
9 - Comet

What a mess this data was

aiahwieder
8 - Asteroid

I'm sure there's a way to get it ALL in a single Regex tool . . . but I couldn't find it 😐

 

Also, I found phone numbers that weren't in the sample output!

Tripti_Lal
8 - Asteroid

Hi Community,

 

Incredible challenge this way! Really worked up by brain! 

 

I had a look at the solution and then came up with my own way. 

 

Hope to hear my fellow members suggestions, if any!

TraceyD
Alteryx Alumni (Retired)

Wow - inconsistent data is hard to deal with!

JP_SDAK
8 - Asteroid

Been working on this one on and off for awhile!  Can't say I agree with the answer (a lot of phone #'s were included with address as a zip code), but I finally got the solution answer to match.  Used a ton of different REGEX expressions then combined them.

Spoiler
JP_SDAK_0-1609437363402.png

 

phoebe_kelley
9 - Comet

The phone number was tripping me up, but I got it 🙂

Spoiler
phoebe_kelley_0-1609444129006.png

 

clmc9601
13 - Pulsar
13 - Pulsar

My solution

rajenderk18
8 - Asteroid

Here is my solution:

 

 

Spoiler
rajenderk18_0-1610115797729.png