Challenge #2: Preparing Delimited Data

[sharsha315]

Hi,

   Here is the solution for the Challenge #2: Preparing Delimited Data.

[Dante_Healy]

Great fun - thanks!  🙂 

[dikshide]

Here is my solution. I will retry this with advanced formula and regex tool when I am comfortable with them.

[Marc_Schmitz]

Here is my solution

[Will_Condon]

[KellyJo_]

Here's my solution to the challenge:

[JPG]

my answer

[KellyJo_]

I am resubmitting my Challenge #2 solution.  I had leading and trailing whitespace, and didn't know what to do with that, so I submitted it with a warning of whitespace yesterday.  Then I saw in my notes that the Data Cleansing Tool can remove whitespace! 🙂

So I fixed that, and now I'm resubmitting my solution, free of warnings. 

Kelly

[ngindam]

Thought this was pretty easy but was pleasantly surprised to see a solution with Formula Tool. I used the DateTime tool.

[AmrSHOULA]

Here is my solution. Good challenge...