AnsweredAssumed Answered

Help with building script for multiple replacements in field

Question asked by Astro0530 on Dec 7, 2017
Latest reply on Dec 8, 2017 by xander_bakker

I have a field that has multiple names for the same company, for several companies.  I would like to build a script to replace the name for each company...

 

example: replace( [OPERATOR],"ANADARKO E & P ONSHORE LLC","ANADARKO")

 

 

FindReplace
ANADARKO E & P ONSHORE LLCANADARKO
ANADARKO E&P ONSHOREANADARKO
ANADARKO PETANADARKO
ANADARKO PET CORPANADARKO
ANADARKO PETROLEUM CORPORATIONANADARKO
CHESAPEAKE LIMITED PARTNERSHIPCHESAPEAKE
CHESAPEAKE OPERATING INC.CHESAPEAKE
CHESAPEAKE OPERATING INCORPORATEDCHESAPEAKE
CHESAPEAKE OPERATING, INC.CHESAPEAKE
CHESAPEAKE OPERG INCCHESAPEAKE

 

How can I build a single script for all replacements?

Thanks!

Outcomes