Is there a reason the data format is so inconsistent? Can we possibly fix this issue at the source by making people input things in a proper manner or are you stuck with it?
Also, just spitballing here but what about using something smarter than us. Fairly sure the google maps api will make short work of any of those and then you can grab the city from that. I don't know the specifics of doing that but certainly sounds doable.
Also, just spitballing here but what about using something smarter than us. Fairly sure the google maps api will make short work of any of those and then you can grab the city from that. I don't know the specifics of doing that but certainly sounds doable.