"You are expecting the data in "City, State" format"

This is a bad assumption. What you should do is throw away commas, split along whitespace, and then see if the last element split is a valid state or territory.

Because some lazy guy will type "new orleans la" and just ruin your day.