From Excel dictionary to Trados TM?
Thread poster: Petr Jezek

Petr Jezek
Czech Republic
Local time: 21:56
English to Czech
+ ...
Mar 23, 2006

Does anybody know if it is possible to create a translation memory in Trados from an Excel (XLS) file serving as full-sentence dictionary? Thanx.

Direct link Reply with quote
 

Fernando Toledo  Identity Verified
Germany
Local time: 21:56
German to Spanish
Easy Mar 23, 2006

Convert the table to text as "Tabs separated"

Save it (txt)

Open it in Word

Search and replace the Tabs also called ^t with

Put at the beginning of the document {0>

And at the end of the document


Direct link Reply with quote
 

Fernando Toledo  Identity Verified
Germany
Local time: 21:56
German to Spanish
Easy Mar 23, 2006

To see the full explanation you will need to clic the "Reply with Quote"



Convert the table to text as "Tabs separated"

Save it (txt)

Open it in Word

Search and replace the Tabs also called ^t with " "

Put at the beginning of the document "{0> "

And at the end of the document "


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 21:56
English to Czech
+ ...
Align with T-Window for Excel Mar 24, 2006

You can align the file with T-Window for Excel, if you have an older version of Trados.

Direct link Reply with quote
 

tectranslate ITS GmbH
Local time: 21:56
German
+ ...
Different methods Mar 24, 2006

Hynek Palatin wrote:

You can align the file with T-Window for Excel, if you have an older version of Trados.

Yes, or with WinAlign in newer versions. That's the safest method, as it will use Trados' own segmentation routines instead of placing segment markers only where the tabs were.

Here's also another take on Toledo's method which I often use:
In Excel, make sure your original language is in column A and your translation in column B. Also, make sure there's nothing else in the file but these two columns.

Then, write the following formula in cell C1:
Code:
=CONCATENATE("{0>";A1;"<}100{>";B1;"<0}")



Copy/propagate this formula to the remaining cells of column C, and then copy the entire column C into a Word file, pasting as "Text Only".

Clean this Word file into your TM. Done.

HTH,
Benjamin

[Edited at 2006-03-24 10:40]


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 »

From Excel dictionary to Trados TM?

Advanced search







CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search