Challenge #16: Parsing Out the New-line Character

[Sidey1978]

Thought I was getting deja vu with this one...

[mambo]

Here is my solution

[atrozz]

Hello, nice exercise to use data cleansing tool. Good luck!!!

Spoiler

First, data cleansing to remove line breaks, next convert Field_3 with dd-Mon.-yy format in string to date and rename fields. So easy with data cleansing tool!!!

[AdamBiggs]

Another one :-) 

[AdamBiggs]

Would help if i added the solution.......

[Mausam]

My solution. Used the 'REGEX_Replace' function from the formula tool instead of the 'RegEx' tool.

[nilaysameer]

Getting the format right for convert took time. Interesting how Alteryx treats the incoming string form Date formats.

[martensite]

my solution!