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

smatthies
7 - Meteor

Posting my 1st Weekly Challenge.

mcultrera
8 - Asteroid

Used FindReplace and Regex.  Regex took some trial and error.  Neither method as efficient as the given solution.

klyuka
8 - Asteroid

Cheers!

ccruzagosto
7 - Meteor

Ended up doing two solutions for this one. The first (in the v1 container) using a text to column. For my final solution I decided to practice my regex skills.

anaibeth
8 - Asteroid

Here's my solution. I removed the commas and quotes with regex and the converted the date.Challenge 2.PNG

DanielG
12 - Quasar
Spoiler
Challenge2pic.png

Didnt add pic the first time I commented.  Here is pic of solution.

SMSatCFA
6 - Meteoroid

This was my first completed challenge!

dmodest
7 - Meteor

My solutionsSolution2b.JPGSolution2.JPG

rohanwaghere
7 - Meteor

Here is my solution:

 

Spoiler
Annotation 2019-06-21 164858 WeeklyChallenge - 2.png

Please find the attached workflow.

Heather_Zhu
6 - Meteoroid

See solution attached :)