Challenge #279: How many Olympic Games per Continent?

[garinmartik]

Solution!

[doates003]

Spoiler

Going for the gold!

[Neetu]

my Solution 🙂

Spoiler

solution1:

solution 2: 

[AngelosPachis]

Challenge #279 is done!

Spoiler

[SophieJoanna]

Spoiler

[AdhirKirtikar]

Here are my solutions:

Spoiler

Solution 1: Fuzzy Match with Find Replace
Solution 2: RegEx

 

[VizChic]

Spoiler

trim:

Spoiler

regex

FG AA soln

[Harrylosborne]

My massively long-winded but trim-less solution:

Spoiler

[Spatial_Sorcerer]

Third challenge down, hundreds to go. Admittedly, I peeked at the solution to find out what tool to use in the non-trim path, but I did come up with the expression on my own.

[Kaitlin-Sheehan]

Spoiler

Spoiler
Used Trim Functionality for Solution One and Text to Columns/Data Cleansing for Solution Two.