Challenge #23: Parsing CPG Data

[tammybrown_tds]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[danilang]

Nice tough one

Spoiler

Dan

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[OllieClarke]

Spoiler

I'm sure this can be done in fewer steps, but this method does work

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jevon]

Great exercise!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[dharini]

My solution below

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[PeterGold]

After quite some time I managed to get a rather simple solution. Find and replace solved many problems.

Also, my first uploaded challenge!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JoBen]

That was a fun one! Thanks! Cheers!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Staal]

My solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[DavidP]

Here's mine - it's always exciting when I get to use 2 of my favourite tools: dynamic select and dynamic rename!!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[KOBoyle]

Solution attached. After confirming the results, I added a separate branch to convert to numbers.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.