Exporting Trados to Excel
Thread poster: xxxSVarley
xxxSVarley
Local time: 00:50
English
Aug 26, 2003

Can anyone help me, Client needs to view and comment on TUs in an Excel file (Clients can be such fun cant they )

Does anyone know how to export without the tags etc?

Any help would be greatly appreciated.

Simon Varley
svarley@translatus.com


Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 19:50
Member (2001)
English to Italian
+ ...
It is possible... Aug 26, 2003

SVarley wrote:
...snip...
Does anyone know how to export without the tags etc?
Any help would be greatly appreciated.


The conversion that you need is not immediate but definitely possible, you just need to work a bit in Word.
I'll try to describe briefly the procedure.


  • Export your Translation Memory (TM) from Trados in txt format.
    You will obtain a txt file containing a number of lines for each translation unit (TU).

  • Delete the section starting with RTF Preamble and containing all style and font information. The closing tag is /RTF Preamble. You should keep just the section containing the TU, having a format similar to the following example:

    (I have repalced the angular brackets with square brackets, otherwise they disappear, ok?)

    [TrU]
    [CrD]17052002, 16:39:11
    [CrU]GFM
    [Seg L=EN-GB]Summer 2002
    [Seg L=IT-IT]Estate 2002
    [/TrU]

  • Count the lines for each TU. They all start with [TrU] and end with [/TrU], include these two lines in your count. In the example the TU contains 6 lines. (and they have angular brackets, not square!)

  • Open the txt file in Word, select all its content and convert text to a table. When asked the number of columns input the number of lines forming a TU (6 in our case)

  • Once the file is converted to a table, delete all columns and keep only the columns containing the actual source and target strings.

  • At this point you have a table in two columns. Replace the language tags with 'nothing' and you are left with a table containing only source and target text.

  • Select this table and paste in Excel. You should obtain a tidy two column table in Excel.


I hope to have understood your needs and that this technique is helpful. It is much easier to do than to describe.

Good luck
Gianfranco



[Edited at 2003-08-27 07:02]


Direct link Reply with quote
 
xxxSVarley
Local time: 00:50
English
TOPIC STARTER
Thanks Gianfranco Aug 26, 2003

I will give it a try


Gianfranco Manca wrote:

SVarley wrote:
...snip...
Does anyone know how to export without the tags etc?
Any help would be greatly appreciated.


The conversion that you need is not immediate but definitely possible, you just need to work a bit in Word.
I'll try to describe briefly the procedure.


  • Export your Trnslatoin Memory (TM) from Trados in txt format. You will obtain a txt file containing a number of lines for each translation unit (TU).
  • Delete the section starting with and containing all style and font information. The closing tag is . You should keep just the section containing the TU, having a format similar to the following example:

    (I have repalced the angular brackets with square brackets, otherwise they disappear, ok?)

    [TrU]
    [CrD]17052002, 16:39:11
    [CrU]GFM
    [Seg L=EN-GB]Summer 2002
    [Seg L=IT-IT]Estate 2002
    [/TrU]

  • Count the lines for each TU. They all start with [TrU] and end with [/TrU], include these two lines in your count. In the example the TU contains 6 lines. (and they have angular brackest!! not square !!)
  • Open the txt file in Word, select all its content and convert text to a table. When asked the number of columns input the number of lines forming a TU (6 in our case)
  • Once the file is converted to a table, delete all columns and keep only the columns containing the actual source and target strings.
    {*] At this point you have a table in two columns. Replace the language tags with 'nothing' and you are left with a table containing only source and target text.
  • Select this table and paste in Excel. You should obtain a tidy two column table in Excel.


I hope to have understood your needs and to be helpful.
It is much easier to do than to describe.

Good luck
Gianfranco





[Edited at 2003-08-26 13:29]


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 »

Exporting Trados to Excel

Advanced search







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 »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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