Exporting Trados to Excel

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

Gianfranco Manca wrote:



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]