Challenge #355: Analyze the Olympic Games

[SitanshuPatnaik]

#8

[Yongcan]

These space is UTF8 version non-breaking space with HEX code "C2 A0".

I notice that too and spend some times to figure it out why my output is not matching the expected result.

https://www.scivision.dev/hex-code-c2a0-non-breaking-space-markdown/

https://en.wikipedia.org/wiki/Non-breaking_space

My solution use a lot data cleansing as Trim function won't help here for ASCII space.

[ricki]

Spoiler

I thought that renaming the columns manually was too straightforward - so I got a nice reminder of Dynamic rename and the Field Info tool, which are both useful and I somehow keep forgetting about the latter.

[TimN]

Hi,

Here is my solution.

[pmag]

Spoiler

[RasmusFormo]

Spoiler

[leonardstarrk]

Renaming by hand is a bit of a drag, but here it goes

[sakifchowdhury1]

Spoiler

 

Challenge 355 solution

[Kushangi3012]

Solution Attached

[Rohit_Pokhriyal]

Thank you!