Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How do I strip a word out of a field using RegEx?

ScottR
Alteryx Alumni (Retired)

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

3 REPLIES 3
patrick_digan
17 - Castor
17 - Castor

@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.

ScottR
Alteryx Alumni (Retired)

Thanks!

It's definitely not any more complex than removing County.  I'll give your formula suggestion a try!

ScottR
Alteryx Alumni (Retired)

It worked great, thanks so much.

Labels