Search and replace from lists?
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Local time: 13:53
Member (2003)
Finnish to German
+ ...
Dec 12, 2007

I wonder if someone has already programmed such a macro. There would be a file with a two-column table and a Word-document. The marco would pick the first string of column A, search for the string in the Word-document and replace all occurences by the string of column B. Then it would pick the second string of column A, search and replace by the second string in column B etc.
This would come in handy it you first have translated a manual with software strings, and later you seperately translate the software strings in form of a table. The macro would update the earlier translated manual.
But such a macro could be used for a lot of other purposes, I would guess.



Haiyang Ai (X)  Identity Verified
United States
Local time: 05:53
English to Chinese
+ ...
VBA Dec 12, 2007

I don't have such a Macro. But it sounds not very complicated. I'm learning Python and right now I can only deal with plain text files. I'll try to write a python script for this later. VBA is not very difficult to learn. Here's some tutorials(try it out if you have time):

Best regards,


Juan Perello  Identity Verified
Local time: 07:53
Member (2005)
Japanese to Spanish
+ ...
Aleksndr Okunev's Tortoise tagger Dec 12, 2007

Though it is originally meant to tag documents according to a previously created taglist,
it can also be used as a utility to search and replace from lists. I just tried it last week. Be sure to read the manual first. You can use the "Fuzzying Wordfast glossary" section as a hint to create your own search & replace list.

Juan Luis


Jaroslaw Michalak  Identity Verified
Local time: 12:53
Member (2004)
English to Polish
Trados? Dec 12, 2007

I have not tried this, but I think you can use Trados for this (yes, it can sometimes be useful!icon_wink.gif ).

First you have to have the list in MultiTerm (if you don't, you have to import it, which, I admit, may be a hassle).

Then you translate automatically the files with an empty TM and the options "Segment unknown sentences" set on and "Translate terms" set to "Replace".

Finally, clean up the files. This should give you back your original files with the MT terms replaced. At least I hope it works this way.

The advantages of this method: you can replace terms in many files at once and you are not limited to doc format.


István Lengyel
Local time: 12:53
English to Hungarian
+ ...
Wordfast blacklists? Dec 12, 2007

Hello Heinrich,

I believe Wordfast can do this by means of blacklisting terms. I never tried it myself, but this is one of the capabilities of the coming term base in MemoQ v2.3 (not a mass find and replace by purpose, but the possibility to enter 'do not use' terms and replace them quickly with the 'use' versions) and when discussing that with some translators they told me that something like that already exists in Wordfast, and it's called blacklist. If you have some solution, please let me know.

Best regards,


GoodWords  Identity Verified
Local time: 05:53
Spanish to English
+ ...
WordFisher Dec 12, 2007

I think such a macro already exists in WordFisher and could be used to accomplish your task in quite a straight-forward way. You would simply have to make a character-separated list version of the conversion table (using Word's "Convert table-to-text") and then run the wfReplace function of WordFisher on your Word document.


Tony M
Local time: 12:53
French to English
+ ...
Another approach Dec 12, 2007

I don't have this as a Word macro, but I do have it as a piece of standalone software currently under development.

It does just that: searches for a given string, and replaces each with an alternative string from a list.

At the moment, it works with a text-only file, and list management has to be done manually; it is also fairly touchy about the order of cascading strings, and dealing with caps and punctuation.

But for the dedicated application I designed it for, it works superbly well, and in about 10 secs saves me literally HOURS of work.

If there is enough interest, I have my developer standing by waiting to pursue the development of the project.

I might add that I started development of this because conventional CAT tools just couldn't achieve what I needed so simply or easily.


Heinrich Pesch  Identity Verified
Local time: 13:53
Member (2003)
Finnish to German
+ ...
Thanks for the information Dec 13, 2007

I have loaded Wordfisher now and will try it out.


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Search and replace from lists?

Advanced search

SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search