Mobile menu

From Excel dictionary to Trados TM?
Thread poster: Petr Jezek
Petr Jezek
Czech Republic
Local time: 14:07
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: 14:07
Member (2005)
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: 14:07
Member (2005)
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: 14:07
Member (2003)
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: 14:07
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


Translation news related to SDL Trados





Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



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