Challenge #279: How many Olympic Games per Continent?

[Maskell_Rascal]

Here is my solution!

Spoiler

I did one solution using Trim and one using RegEx. I also didn't bother breaking them out into three separate outputs, but that would be easy enough to do if needed. 

Cheers!

Phil

[DaisukeTsuchiya]

Spoiler

 

[dYoast]

My solutions.  I chose not to CAPITALIZE everthing.

Spoiler

[AkimasaKajitani]

I made two solutions not used trim.

Spoiler

[balajilolla]

Spoiler

Solution Attached

[ggruccio]

Europe is the clear winner!

Spoiler

My two ways were, one - using the trimleft and trimright to remove the unwanted characters and two - using the Text to Columns tool to parse out the '[' and data after as a separate column for the Europe[h] issue then remove all punctuation using the Data Cleanse tool.

[ryan-bush]

Solution attached

[patrick_digan]

Spoiler

I used regex and replace functions for a dynamic/non-dynamic solution.

[mike_w]

I almost missed the "provide 2 solutions" part bc I was so eager to start 😋 

Spoiler

one solution is mainly based on the Summary Tool , the 2nd one mainly on the Multi Row Formula Tool! No Trimming Tool was used.

[phottovy]

Two solutions (which you can try using the underutilized detour tools), no trim functions: 

Spoiler

Unless regex counts as a trim function...