Challenge #319: Sports Spots

[mithily]

ok ok I dont know anything about sports

[lwolfie]

I got a slightly different answer when I used league vs team.  But here's my answer.

[BransonJamesFarley]

Fun!

Spoiler

 

[cmoussa]

[JBevan89]

My Solution attached.

It took me a while because I did not connect the input files in order, which resulted in the League in the answer being different

[AbhayNawani]

completed

[mwong]

Was a fun challenge!  My solution:

[Bennu]

Anyone out there: is there a way to extract via REGEX PARSE both city and state for both records containing both city and state and records containing only city?

EG: Charlotte, North Carolina
       Vancouver

So that we'd get 2 columns but NULL when there's no State.  Yes, I could use tokenize with [^,]+ or text to columns, but i was wondering if there's a way via RegEx Parse.  Thanks!

Spoiler

[DylanBell]

As an Englishman, I follow none of these sports.

[RebekaMazuchova]

:)