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 #36: Data Cleansing Extract Authors

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
Natasha
9 - Comet

I tried the summarise tool at the beginning but there were not enough space to concatenate all authors, so took another approach with a cross tab. 

Spoiler
Screen Shot 2017-10-29 at 17.25.06.png

 

JoshKushner
12 - Quasar

I am quite please with how elegant this solution is. EXCELENT challenge.

Spoiler
Capture.PNG
samN
10 - Fireball

Regex will never fail me...I hope

ggruccio
ACE Emeritus
ACE Emeritus

More fun with parsing and assembling tables!

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
challenge_36 - Snip.PNG
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

my good old multirow friend.

 

Spoiler
challenge36.png
jamielaird
14 - Magnetar

Solution attached. Nice example of why I never rely on commas as delimiters if I can help it.

 

Spoiler
Screen Shot 2017-12-26 at 21.37.53.png