I am standardizing a list of city names from numerous abbreviations. I am
stuck on how to update part of the city name if it occurs at the end.
For instance, HTS is an abbreviation for Heights. I can successfully
update Vadnais Hts, and Mendota Hts, but not Oak Park Hts as it begins the
replacement after the first space, not the second, or perhaps even third.
Thank you.
____________
Kent Treichel
Analyst-GIS
Tax Research
Minnesota Department of Revenue
MS 2230
600 North Robert St
St. Paul, MN 55146-2230
651-556-6150