Hi,
I have a field consisting of county names in the format "Boulder County". I'd like to strip off the word "County" and just leave the county name. The kicker is several of the counties have multiple word names like "El Paso County". I am sure RegEx can do this but I am a novice, novice RegEx user. Any help would be awesome.
Thanks,
-Scott
Solved! Go to Solution.
@ScottR What about something like a replace formula:
replace([Field]," County","")
Regex may have a place if your situation is more complicated than your example.
Thanks!
It's definitely not any more complex than removing County. I'll give your formula suggestion a try!
It worked great, thanks so much.