I have data on a metropolitan area and want to extract out the city info.
An example is
test <- c("Akron, OH METRO AREA","Auburn, NY Micro Area","Boston-Cambridge, MA-NH")
And I want it to look like
"Akron, OH", "Auburn, NY", "Boston-Cambridge, MA"
So just the City, State