Challenge #188: Difficult, but not im-parse-able

[dpencheva]

Here is my solution. Probably is not the shortest one but it works properly. ; )

[AndrewS]

#188

Spoiler

[johnemery]

This was a good challenge. Made me stop and think about how to go about it. Like usual, regex came to save the day.

Spoiler

[balajilolla]

Spoiler

Solution Attached

[hanykowska]

Hmm, not quite happy about some of the things being asked here

Spoiler

1) Why do the dates need to be changed from the perfectly fine format of yyyy-mm-dd to mm/dd/yyyy? This doesn't sound like a good idea
2) For the type of KG, the numbers end with a hyphen in the original data, in the output they are negated. Is there anything that I've missed?

Anyway, managed to get it to work:

[CKP]

My solution

Spoiler

[Mengdee]

not too bad actually.. easier then it looked

[sonyakasenkramer]

I had my heart set on using dynamic renaming for the fields and not hard coding them in a Select tool. That added some complexity.

[phottovy]

Finally got it!

Spoiler

[wwatson]

my solution