Interlace translation with source text, on alternate table rows
Thread poster: xxxUSER0059
xxxUSER0059  Identity Verified
Finland
Local time: 12:32
English to Finnish
+ ...
Jul 3, 2008

Hi,

A recent client wished for their translation to interlace with the source text, on alternate rows in a Word table, like this:

source segment 1
target segment 1
source segment 2
target segment 2
source segment 3
target segment 3

The client would also have supported RTF as well as the Excel workbook format.

As I use SDL Trados, I first translated the entire text in Translator’s Workbench, as usual, and then pasted the target rows into the source document, one at a time. This did work, although it might be impractical in large assignments. I therefore wonder whether it would be possible to automate this.

(If not, I guess I could translate manually, entering the translation on the rows provided, and use WinAlign afterwards.)

Your ideas are welcome.

With regards,

Thor Kottelin


Direct link Reply with quote
 

tectranslate ITS GmbH
Local time: 11:32
German
+ ...
Easy Jul 3, 2008

If you have the slightest bit of Excel knowledge this is a piece of cake.

I would propose to:

  1. make an "index column" by adding a new column next to the existing data and filling it with ascending numbers (1, 2, 3, 4, etc., one for each row)
  2. translate the file (keeping a backup, of course)
  3. copy the original lines from the backup of the prepared file below the translated lines or vice versa
  4. modify the index column for the translated lines to be [previous value] + 0.5. There are several ways to do this, either through a formula that says "=a119+0.5" or similar and that you copy over the cells or by auto-filling the cells - how you do it is up to you.
  5. sort the table by the index column.
  6. remove the index column. Voilà.


HTH,
Benjamin

[Edited at 2008-07-03 12:12]


Direct link Reply with quote
 
xxxUSER0059  Identity Verified
Finland
Local time: 12:32
English to Finnish
+ ...
TOPIC STARTER
Brilliant! Jul 3, 2008

tectranslate wrote:


  1. make an "index column" by adding a new column next to the existing data and filling it with ascending numbers (1, 2, 3, 4, etc., one for each row)
  2. translate the file (keeping a backup, of course)
  3. copy the original lines from the backup of the prepared file below the translated lines or vice versa
  4. modify the index column for the translated lines to be [previous value] + 0.5. There are several ways to do this, either through a formula that says "=a119+0.5" or similar and that you copy over the cells or by auto-filling the cells - how you do it is up to you.
  5. sort the table by the index column.
  6. remove the index column. Voilà.

[Edited at 2008-07-03 12:12]


This makes perfect sense. Thank you!


Direct link Reply with quote
 
FarkasAndras
Local time: 11:32
English to Hungarian
+ ...
even easier Jul 3, 2008

If you're happy with losing formatting (probably even bold letters and sizes etc.) or there is none to begin with :
Just take your uncleaned file, copy to excel, then to notepad and back to word, to make the trados tags and hidden text all turn into regular text. There may be a more elegant way of doing this.

search and replace all the trados tags (they all contain { and } ) with line breaks (^p).

Remove double line breaks if you feel like it (replace^p^p with ^p)

Of course the whole thing will be segmented according to TUs so one would need to make sure during translation that 1 TU=1 sentence.

Edit: oops, you need a table... then just throw it back and forth between word and excel again, skipping notepad this time.

[Edited at 2008-07-03 12:34]


Direct link Reply with quote
 
xxxUSER0059  Identity Verified
Finland
Local time: 12:32
English to Finnish
+ ...
TOPIC STARTER
Thanks, FarkasAndras Jul 4, 2008

Thank you for the alternative solution you offered! I will keep it in mind.

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 »

Interlace translation with source text, on alternate table rows

Advanced search







WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
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 »



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