Challenge #16: Parsing Out the New-line Character

[pmyung87]

Here is my solution. 

[WH]

Spoiler

2 Ways have been used to remove embedded new line:

1. Text to Column by "\n" and then use formula to add the fields together
2. Use formula "Regex_Replace([Field_1], "\n", " ")"

[gcarroll]

Solution attached!

[Verakso]

Nice with a beginner challenge again, now my faith in myself has been restored 😂

It was nice for once to come back to a simple challenge, that I could solve by my own.

Spoiler

 Seems afterwards, that my approach wasn't that much different that the provided solution, so I am just happy to be on the right path

Br

/Thomas 

[Verenala4]

Hi,

My solution is below. It took me a second to realize why my date-time tool wasn't working but nice challenge.

V

Spoiler

[JoshuaM]

Quick and easy challenge!

[rfergus]

Spoiler

[TharunReddy]

I used RegEx and DateTime.

Happy Practice :)

[Thableaus]

Challenge #16, done.

Spoiler

Cheers,

[sharathkumargurram1]

Hi,

Uploaded the solution.

Best Regards,

Sharath Kumar Gurram.