Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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!