How to Bulk Edit Location Data for Contacts in Your Database

Hey guys -- Is there something I can do to change all of the data on the 'location' column of each contact? It comes up with, for example: "New York City, New York, United States" or "Miami, Florida, United States" Is there a way I could bulk change them all to just "New York City" Or "Miami" so just shows the city, or state?