Challenge #16: Parsing Out the New-line Character

[BS_THE_ANALYST]

Used the Data Cleansing tool to remove the line breaks. I'm looking forward to learning Regex to tackle this kind of question. 

Spoiler

[kaitlinDS37]

Spoiler

[flavio-matos]

My solution

Spoiler

[Minsu]

Here is my solution!

[ydevis]

Spoiler

[TyroneW]

Solution:

[mkreddy]

I tried to remove new line character using delimiter "\n" and then used the Date-time tool to convert string to date, finally some selection and renaming

[mswartzentruber]

Solved. I used the Data Cleansing tool rather than RegEx. RegEx seems more straightforward.

[HannahLaughton]

Done!

[CammyPhillips]

Spoiler