Challenge #16: Parsing Out the New-line Character

[LittleE]

That was a cleansing experience.

Spoiler

[troyeb4]

See my flow below, solution attached.

Spoiler

[Samanthaj_hughes]

Mary had a little lamb....

[jsenk]

Solution

[CharlesZ]

[matt_un]

Spoiler

[fluteman]

This one was straightfoward.

I used this to derive the month value: (there is preceding code)

IF [Current_Month] = 'JAN' THEN '01' ELSEIF [Current_Month] = 'FEB' THEN '02' ELSEIF [Current_Month] = 'MAR' THEN '03' ELSEIF [Current_Month] = 'APR' THEN '04' ELSEIF [Current_Month] = 'MAY' THEN '05' ELSEIF [Current_Month] = 'JUN' THEN '06' ELSEIF [Current_Month] = 'JUL' THEN '07' ELSEIF [Current_Month] = 'AUG' THEN '08' ELSEIF [Current_Month] = 'SEP' THEN '09' ELSEIF [Current_Month] = 'OCT' THEN '10' ELSEIF [Current_Month] = 'NOV' THEN '11' ELSEIF [Current_Month] = 'DEC' THEN '12' ELSE '12' ENDIF

[szade1]

Here's my solution:

Spoiler

Thanks,

S.

[JoePC]

Solution Attached

[DemandEngineer]

I imagine this was harder before the data cleansing tool.  Would have had to use formula tool with string functions I would imagine.