Challenge #138: World Series Wins

[AdamBiggs]

After looking at some of the solutions this was a long way round it, but we got there.

[bdelarosa]

Spoiler

Spoiler


Am I the only stubborn one here who will not cheat and see others solutions, till i at least come up with my own solution even though I may have went with the longest way about solving it? 🙂

[KevinH1992]

Spoiler

More complicated than it probably needed to be but had some issues with regex so I ended up using ParseToColumns followed by some selects..

[RWvanLeeuwen]

I'm not into sports and so I do not know what the (numbers) and [labels] mean. It seemed to me that I did not need it so I removed them rather than parsing them into a new field.

Spoiler

[chaddzivic]

Here is my solution. I circumvented RegEx and used 4 text to columns instead. I just don't want to learn RegEx yet 🙂

Thanks,

Chadd

[chaddzivic]

Correcting to show 0% for teams that appeared but never won.

[CliffordC]

Not the prettiest but it gets there.

[MikeHinz]

Probably took the long way but I made it to the solution

[AntoineR1509]

Here is my solution for this problem

[mbogusz]

Spoiler

@neilgallen thank you for your Regex wizardry

Go Yankees