Converting a glossary into the SDL Trados TM using the Tab Delimited Text filter

In my previous post, I discussed how to convert a glossary into the SDL Trados TM using ApSIC Xbench. In this post, I will explain a more simple way to convert a glossary into the SDL Trados 2011/2014 TM using the Tab Delimited Text filter.

1. First, convert a glossary file into a tab-delimited text file. For a glossary in Excel format, simply coping and pasting all entries into a text file will creates a tab-delimited text file. (Or you can also save it as tab delimited text file or a comma delimited text format.) For example, it will look like the following:

A sample tab-delimited text file converted from an Excel file. The arrow indicates a tab.
A sample tab-delimited text file converted from an Excel English-Korean glossary file. The arrow indicates a tab.

2. Go to "Tools" > "Options," and select "File Types" and then "Tab Delimited Text." (If the format of the glossary is CSV (Comma Delimited Text,) please select "Comma Delimited Text (CSV)" instead.)

3. On the "Format" tab, specify settings as shown in the following figure:

Settings of "Format" section of the Tab Delimited Text filter
Settings of "Format" section of the Tab Delimited Text filter

4. Now, you can open the document for translation by clicking the "Open Document for translation" icon in SDL Trados Studio (or "File" > "Open" > "Document" in the SDL Trados Studio menu.)

In the "Open Document" dialog, please select "Tab Delimited Text Documents" as the File Type.

File type in the Open Document dialog in SDL Trados Studio
File type in the Open Document dialog in SDL Trados Studio

5. When the document is opened in the SDL Trados Studio Editor, you can save it and then perform Batch Tasks to update TM. (Or, you can use SDLXliff2Tmx to export the sdlxliff file to a tmx file.)

SDL Trados Studio Editor

There are several ways to import the glossary entries into a Trados TM. In this post, I explained how to convert a glossary into the SDL Trados TM using the Tab Delimited Text filter. If you are familiar with regular expressions, you can easily convert a tab delimited text file into a tmx file using the following setting in the Find & Replace feature:

Find: (.*)\t(.*)

Replace with: <TrU>\r\n<Seg L=EN-US>\1\r\n<Seg L=KO-KR>\2\r\n</TrU>

(Language codes need to be changed according to your language pairs.)

This method is simpler to follow (Please refer to this post.)

 


Leave a Comment

3s