Challenge #16: Parsing Out the New-line Character

[dharini]

Here is my solution

[kat]

Spoiler

[Carlithian]

Heres my solution

[AidanBramel]

My solution, can't imagine it's different than most of the rest. :)

[Lee_Gibbons]

Solution Attached :D

[gmartin]

Here is my solution!

Spoiler

[tammybrown_tds]

I hope the fact that this one was easy is a sign that I am getting more comfortable with the tools!

[pasccout]

Here is my solution...

Although... the output from the start file show \n replaced by nothing... the object does replace it with a space...

[TimothyB]

My Solution Data Cleanse, Formula to parse and re organize date string, Selection to drop a column and Format V_String to Date

Spoiler

Formula to rearrange date string: "20"+Right([Field_3], 2)+ "-" + IF (Right(Left([Field_3], 6),3))="JUN" THEN "06" ELSEIF (Right(Left([Field_3], 6),3))="DEC" THEN "12" ELSE "" ENDIF + "-" + Left([Field_3], 2)
Note: can easily add to ELSEIF statement to map all 3 Character Month String Values

[Vinutha]

This one was fun. Love using RegEx; loads to learn about this tool.