Challenge #16: Parsing Out the New-line Character

[gjjadhao]

Spoiler

Solution is attached !!!

 

[Bo]

Hi friends, 

I used a formula tool and I put "datetimeparse([Field_3],"%d-%b-%y")" and however, it returned me "2001-06-1" instead of 2001-06-16. I am not sure where went wrong. Thanks

[Leonard_Ellis]

My solution attached:

[ALTSkelly]

Spoiler

 

[danielhoge]

Spoiler

[Tgigs]

My solution attached.

Used data cleansing tool to remove the new line characters, then date time parse tool with custom format dd-MMM-yy to convert the date field to date type, and select tool to select and rename the fields for output.

[MDestra]

Challenge #16

[moszcar111]

Here is my work

[ArisaOkada]

Seventh workflow!

[Spainey]

My submission attached: