Challenge #2: Preparing Delimited Data

[jamiebassett]

Definitely could do less steps in the future when I get better

[AlexSimpson]

My solution:

Spoiler

Spoiler!

[kmickelson]

Posting my solution.

[abhishekyx]

Hi,

Thank you for the solution.

I am new to alteryx and learning from different resources within the community for which I would like to thank everyone here.

In solution to challenge #2 I did not get the %b date format in "DateTimeParse(trim([3],"'"),"%d-%b-%y") 

As per the document it is "mmm" format for %b and "MMM" format for %B but when I am changing it to some other value as per the learning document I am not getting the desired result. 

Could anyone please help?

[rmccaule]

My solution

Spoiler

[jarjarbingie]

Spoiler

[rmforcreamlisa]

Here is my solution.  Plugging away at getting my badges.  Thanks

[nelsonr]

My answer. It works as long as the input file has a standard format.