I am looking up posts about extract pattern to find help for my problem.
I’m trying to extract the city name in a field. The field has punctuations and often times has Zip codes and other times the State. Here are some examples of the field.
Denver. 80211
Denver CO CO
Aurora,
Littleton, CO CO
Denver 80128
Littleton CO. 80411
How do i grab the first city only? Im thinking of removing the numbers and punctuations, but don’t know how. Thanks
Best answer by JMoore
View original