Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThese 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.
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.
Challenge 355 solution