Challenge #2: Preparing Delimited Data

[archietao]

Took me longer than i thought for this one.

[Verakso]

Second challenge and my third, so only 133 to go 😃

Spoiler

I must admit the conversion of the date was the biggest challenge to me.

Originally I tried to use the Formula tool, but I could not get the formula right, so I used the DateTime parser, and then added the Select to make sure the output match the solution output.

On to the next
/Thomas

[MarqueeCrew]

@hkeith,

Thank you for your post to Challenge #2.  I have never used StripQuotes() before.  You've taught me something new today.

Cheers,

Mark

[Paul_Cornmell]

I found the date conversion the most tricky bit. Struggled to do it by formula so took a few extra steps and tools than the suggested solution. Got there in the end!

[Samuel_To]

Hi ,

This is my workflow. This challenge is a good example to show that there are many ways to handle the date field.

For example, using Formula Tool or DateTime Tool.

Thanks and Regards,

Samuel

[joona_rauhamaki]

Here is my solution

[DanLarbalestier]

Good challenge, my original solution wasn't quite as pretty, but it was understood when replicated

[anhtran]

Hello, please find attached. Just want to practice Parse function so longer steps were taken.

Thanks.

[Shailesh_134840]

ried as my first challenge. Attached the yxmd file. 

[Mac]

My take on it...