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 #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 :)