Free Trial

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 #2: Preparing Delimited Data

Shevans
6 - Meteoroid

Love these!  Solution attached :) 

 

Shevans
6 - Meteoroid

Love these!  Solution attached :) 

 

Pavel_G
6 - Meteoroid

My first challenge.

 

#2.png

SeanAdams
17 - Castor
17 - Castor

:-) nice one @Pavel_G - these are a truly great way to learn.

70 or so to go - but your next milestone is at 5 when you get the next badge!

 

Happy hunting!

Pavel_G
6 - Meteoroid

 


@SeanAdams wrote:

:-) nice one @Pavel_G - these are a truly great way to learn.

70 or so to go - but your next milestone is at 5 when you get the next badge!

 

Happy hunting!



 Thank you @SeanAdams! I'm done with my second one (#7) already. )))

Auditor
5 - Atom

WC#2: Attached is my regex based solution.

LordNeilLord
15 - Aurora

workflow

irisTZ
5 - Atom

Solution for #Challenge 2

KOBoyle
11 - Bolide

Solution attached.  For the Text to Columns parse, used the Advanced Options to prevent errors if a comma were to be present within the data.

 

Ken

A_Twa
8 - Asteroid

I took a few more steps to get there than the official solution, but that's given me some ideas for how to optimize my other workflows.  Thanks!