How can I keep Excel cell content in one segmentation

Question

Hi, I want to keep the contents of the cells in my excel file as independent segmentations in my Trados .sdlxliff file, but when preparing the Trados file, if there is a '.' a new segment is created. How can I prevent this from happening? 
 Thanks in advance, 
 Alberto.

Paul · Accepted Answer

Alberto Iturbe 
 
 You didn't tell us what version of Studio so here's 2021:

Paul · Answer

Same place as you set the para segmentation Alberto Iturbe

Paul · Answer

Alberto Iturbe 
 Interestingly if you work the other way around you can do this. 
 First start with my Excel file: 
 
 Create a project using a standard sentence based segmentation. Translate the sentences you want: 
 
 Now update the same source file with a paragraph segmented TM attached to your project (note I disabled my sentence based and enabled my para based): 
 
 Update the file: 
 
 Now I have this: 
 
 I have no idea why I'd want to do this, and nor do I have any idea why it doesn't work the other way around because I expected it to. But it's interesting... and I'll log it as a bug/enhancement because I think it should work.

Paul · Answer

Alberto Iturbe 
 There is a good argument for why it won't work the other way around of course. If you had translated a paragraph, and used two sentences in the target, or four even, where the source had three then how should Studio handle this? Where should it put the translations? 
 I think we could allow this if the para segments were empty, or always put the translations in the first segment only for example. So some sort of rule... but I think this is probably why it doesn't work the other way around. 
 Why do you want to do this? Is it because you want the right segmentation for each cell? In this case perhaps the right answer is actually to simply delete the full stop rule and then you always get this: 
 
 Each cell treated exactly as you want.

Paul · Answer

Linus Wang 
 For this you should simply add "Maint." to your abbreviations list and then it won't segment there. You will need to make this change to all 15 TMs but this is made easier if you use the ApplyTM Template application from the appstore: 
 https://appstore.sdl.com/language/app/applytm-template/966/

Paul · Answer

Alberto Iturbe 
 Try creating a TM that has paragraph segmentation, Then when you open your Excel file with this TM each cell should be a separate segment.

Jerzy Czopik · Answer

Alberto Iturbe said: One last question, if I change those settings in a TM of project I am already working on, does it work on the files of that project which is half-way through? 
 No. You have to start again, as the files are already segmented. 
 You can also use the same TM with no segmentation change, but instead of Excel file type use Bilingual Excel. This, however, will work only, if you have a source column and a target column. If the complete Excel file is to be translated, you have to change the segmentation.

Trados Studio > 1. Trados Studio

How can I keep Excel cell content in one segmentation

Top Replies