Challenge #138: World Series Wins

[hanykowska]

Turns out there's a very weird character between team name and score. It's not a white space - Show Whitespace in  Cell Viewer doesn't show anything for that part so I don't know what it is. I've found my way around it although not a very good one... If you're not using crew macros you probably won't even notice this

[TonyA]

Here's my solution.

Spoiler

Nothing terribly creative. I was trying to eliminate RegEx and the data cleansing tool almost worked except for the period in St. Louis. I would love to see periods and commas each called out as a separate cleansing criterion in the Cleansing tool. That would also make it easier to eliminate commas when converting number strings.

[Emmanuel_v]

My solution!

[nikolaskardasis]

Spoiler

[hbraunius]

My solution attached.

[elliemason]

Probably could have used fewer tools!! 

[Kenda]

Spoiler

[MsBindy]

I was challenged by that space or character after the team names that wouldn't cleanse.

My solution is logical (in my mind)  but not as elegant as others.

[harterjay]

my solution... struggled a bit with regex - but I think it makes it more efficient.

Spoiler