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

Geoowl
7 - Meteor

Solution Attached.

 

I used Replace rather than trim and i found removing the " marks a bit more confusing as you cannot contain within "".

cjameson
6 - Meteoroid

Solution attached. 

Breanne
7 - Meteor

Challenge #2 seemed easier than the first!!

barbara_m
6 - Meteoroid

My Solution - one step more than the recommended solution

payam2
8 - Asteroid

We actually did this during the training course. Here's how I solved it.

grodge13
7 - Meteor
Spoiler
My solution involved the Text to columns tool followed by the DateTime tool custom string 'dd-Mon-yy'
ChadderBOX
7 - Meteor
 
JMX
7 - Meteor

Working out the formula to format the date properly was the biggest struggle for me on this one. Other than that not bad. 

barbara_m
6 - Meteoroid

I found the parse date-time tool using a custom date including the single quotes: 'dd-Mon-yy' made it really easy.

SevenConsulting
6 - Meteoroid
Spoiler
Screen Shot 2018-09-21 at 12.31.31 PM.png

First time using the DateTime tool! Now I wish I had used it in challenge 4 :P