Conversion/Replace Sa in SA and Gmbh in GmbH etc
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.. !