• State Verified Answer
  • Replies 2 replies
  • Subscribers 432 subscribers
  • Views 2513 views
  • Users 0 members are here
Options
Related

Is it possible to segment a bilingual Excel file by something other than cells?

Beatriz Viera

I am using Studio 2015 to process a bilingual Excel file. I have my source in column A and the translation in column B. Each cell is a paragraph containing 2 or more sentences. When I add to Trados, my file is segmented by cell, so each of my segments in the Editor view contains the entire paragraph. I'd like to be able to segment by sentence, so that I can add sentenced based TUs to my TM. Is there a way to do this with a bilingual Excel or even a different file type?
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0
    Hi Beatriz,

    I'm afraid you can't do this with any of the bilingual filetypes. So not Excel or CSV for example. Segmentation is always done on the cell... and I believe this is the same in other tools as well for a bilingual file.

    You can do it if the file is treated as monolingual. So a possible solution might be to create two files with only content where you actually had a translation already in the Excel, and create translation memory from it. Then open the Excel as a monolingual file with a copy of the source in the column that should contain the translation, and the original source column hidden. Pre-translate with your TM and you'll be good to go.

    If the excel file doesn't contain any translations yet then it's easy... just copy source into the target column, hide the source and translate as a monolingual file.

    Regards

    Paul

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Reply
  • 0
    Hi Beatriz,

    I'm afraid you can't do this with any of the bilingual filetypes. So not Excel or CSV for example. Segmentation is always done on the cell... and I believe this is the same in other tools as well for a bilingual file.

    You can do it if the file is treated as monolingual. So a possible solution might be to create two files with only content where you actually had a translation already in the Excel, and create translation memory from it. Then open the Excel as a monolingual file with a copy of the source in the column that should contain the translation, and the original source column hidden. Pre-translate with your TM and you'll be good to go.

    If the excel file doesn't contain any translations yet then it's easy... just copy source into the target column, hide the source and translate as a monolingual file.

    Regards

    Paul

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Children