Challenge #2: Preparing Delimited Data

[DE0413]

Late to the game, but attempting to complete the challenges without reviewing the solutions.  Attached is my solution.

Best wishes,

Denise

[Phil_L57]

Hi GeneR,

Used the data cleansing tool to clean the punctuation from the first 2 columns then used the following custom date format in a datetime tool:

'dd-Mon-yy'

Phil

[LordNeilLord]

Great opportunity to use the Date Time Tool :)

Spoiler

[ydmuley]

Here we go for the second one. I found this one very easy. Except had to research on date format, a new learning for me. Also, I have used the Data Cleansing tool which is just awesome and easy one. Comments? Suggestions?

2 Down....

[mceleavey]

So far so good.

The data cleansing tool saves a lot of time.

[SeanAdams]

nicely done Yug - I've not used the "StripQuotes" formula before, so that's fun to see.

2 down, 67 to go :-)

[ydmuley]

Agreed @mceleavey - Kudos to the team to maintain the simplicity and easy of handling of this tool with some amazing powers!

[ydmuley]

Thanks Sean - Will be targeting 3rd one now

[sagarb]

Late to the party!!

[raj_k]

Solution for Challenge # 2