Cloud Quest #7: Marvel-ous Comics

[geoff_zath]

Spoiler

 

[RWvanLeeuwen]

So if the Replace() function in the formula tool is broken, what do we do?

Yes, we use workarounds like regex

Spoiler

[JoachimCaronTIL]

Here is my solution

Spoiler

 

[Ladarthure]

my solution, good warmup with regex!

[Jean-Balteryx]

Here is my solution !

Spoiler

[ScottMcV]

Mine is a little long and non-linear because I tend to think very incrementally.  So extract the year, remove the year, remove the issue... so I can go back and modify or reuse the bits.  The core is the same as others I suspect (join, regex, summarize, unique/sample, sort).

Spoiler

[Qiu]

@AYXAcademy 
This is a nice one. Thanks.
Similar with my case, and observed from someones snapshot, it seems that the "#" is not allowed as Field Name?
In my case, it will be forced to turned to "_".
But in the answer file, the # is showing correctly.

Spoiler

[Shelbey]

I chose to use the Unique tool instead of the Summarize tool like the hint suggested.

Spoiler

[Towers]

always love a bit of regex

Spoiler

 

[mceleavey]

Another one in the books. 

Spoiler

Joined them accordingly, used regex to parse out the Year, summarised into the appropriate grouping (Task 1). I then removed the empty year rows and sampled the first record of each group where the grouping was by CharacterID and the sorting was ascending on 
Year and Issue No.