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

Koji_B
8 - Asteroid

Here is my solution

Dazzerman
11 - Bolide

This challenge was a hard one to get my head around the data!  Also found an extra phone number with the Regex I came up with.

 

Spoiler
Challenge20.jpg
DataTester
8 - Asteroid
 
DataTester
8 - Asteroid
 
Inactive User
Not applicable
 
JamesCameron
8 - Asteroid

My effort. Plenty of brute force and ignorance, not much elegance!

 

Spoiler
JamesCameron_0-1574167046194.png
Lily_Unsworth
8 - Asteroid

That was hard.

KolsumaAktar
8 - Asteroid

solutions attached

mheinze
Alteryx
Alteryx

Very challenging one. Found a few records that look like they have mangled phone numbers in the address field that the solution does not split out. 

moritzsturm
7 - Meteor

Solution attached with a few improvements over model output.

 

More specifically, duplicate whitespace was removed and phone number was recognized (i.e. split from address) for the following:

 

  • Group O
  • GM Customer Relationship Management
  • Regency Direct Marketing (I) Pvt. LTD
  • Metrics Marketing Group