AnsweredAssumed Answered

Conversion/Replace Sa in SA and Gmbh in GmbH etc

Question asked by wimrippen on Dec 7, 2012
Latest reply on Dec 10, 2012 by wimrippen

Title

Conversion/Replace Sa in SA and Gmbh in GmbH etc

Post

     I have world-database with 10.000  Companies with linked Products database via Company field in both. AAbbcc=AAbbcc.

      

     How to make script to find/convert Companies like ....Johnson Sa into Johson SA ...and ...Weber Gmbh into Weber GmbH...

     and similar business forms. I have to change both in order to maintain the effective link.

      

     It is too complex doing it manually, so I wonder with a basic scipt it could be converted,later I can extend it

     to similar  business forms like Spa/ CV de SA , B.V. into BV and N.V. to NV.

     Thanks for help/ideas.. !

     William

      

     . 

Outcomes