Mobile menu

Search and replace in Word
Thread poster: Silvy Codde

Silvy Codde  Identity Verified
Local time: 10:53
Member (2004)
English to Dutch
+ ...
Aug 26, 2006

Hello everybody,

I have a Word document to translate: table with source text in first column and target text in second column.
Text to be translated are software strings, all in this format:
"bla bla bla"
Now I would like to to able to skip the quotation marks (there are about 10000 lines, all starting and ending with "). Is it possible to do something with the search and replace function in Word to put these quotation marks at the beginning and at the end of every cell? Or otherwise in Excel maybe? (then I would export)

Many thanks in advance for your reply !

Direct link Reply with quote

Jerzy Czopik  Identity Verified
Local time: 10:53
Member (2003)
Polish to German
+ ...
Search for " and replace with " formatted with TW4WinExternal Aug 26, 2006

This is very easy - just open the S&R function in Word, click on advanced.
In Search for put simply the ". In Replace with put " and additionaly click on Format and select Style, then select TW4WinExternal.
If you do not have the style, first press ALT+F8, than put sAddTagStyles in the field and let it run.
Than you will have the necessary style in your document.
You can also select the whole source column and assign the same style to it. In this way Trados will skip it too.


Direct link Reply with quote

United States
Local time: 04:53
English to Spanish
+ ...
Excell Aug 26, 2006

The search and replace function will work with this, but it could have potential mishaps _Ie: What is the source code has a print or other statement where the quotes are used inside the string.

Since it is software source code, the best thing to do in my opinion is to transfer the table to an excel document, 3 columns, and then make sure one column is the open quote, the next column is the text and the next Colum is the closing quote.

In that way, you are sure that each element is where it belongs very simply by scanning the content of the columns, then you can resave the excel document as a text document.

Arturo Pinzon – SpanishTech – Market tested Spanish Translations

Direct link Reply with quote

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 in Word

Advanced search

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

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

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

More info »

All of
  • All of
  • Term search
  • Jobs