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

pmwillen
7 - Meteor
Spoiler
Text to Columns --> Date Convert --> Select

 Challenge 2 solution attached.

JordyMicheal
11 - Bolide

Think the tools i used weren't around in 9.x

jjdennis
7 - Meteor

Another down.  Lots to go.

Jbrown18
5 - Atom

I got the solution, however I know there has got to be a better way of combining the text to column steps I have. 

 

Open for suggestions!

wspear
5 - Atom

I ended up doing a near-full run on the parse tools - but I do prefer how concise + compact the official solution is.

tariqhussain
6 - Meteoroid

Solution to number #2

JPMelnitsky
7 - Meteor

Here is my solution..

MarcyB
5 - Atom

Here's my solution.

arein0
8 - Asteroid
 
ebarrus
7 - Meteor