Open Excel file in Trados Studio with Cell settings
Auteur du fil: Ahmed Maher
Ahmed Maher
Ahmed Maher  Identity Verified
Local time: 23:06
anglais vers arabe
+ ...
May 26, 2014

Hi all,

I have Excel file with 2000 cell. It is one column and 2000 rows. I want to open it in Trados Studio, so that I have only 2000 segments.
In my file, every cell contains more than one sentence separated by fullstops. As you know, Trados consider every single sentence as one segment.

I have tried with Files Types settings, but can not see such option available for Excel 2007.

Thanks very much in advance.


 
RWS Community
RWS Community
Royaume-Uni
Local time: 22:06
anglais
Easy enough :-) May 26, 2014

Hi Ahmed,

Just change the segmentation on your TM to be used for paragraph based segmentation instead. With an excel file each cell is considered to a paragraph. So if you segment based on paragraph instead of sentence then you'll see the desired result.

You can find this ins Translation Memories -> Settings -> Language Resources -> Segmentation Rules. It's just a check box:
... See more
Hi Ahmed,

Just change the segmentation on your TM to be used for paragraph based segmentation instead. With an excel file each cell is considered to a paragraph. So if you segment based on paragraph instead of sentence then you'll see the desired result.

You can find this ins Translation Memories -> Settings -> Language Resources -> Segmentation Rules. It's just a check box:


Regards

Paul
Collapse


 
Ahmed Maher
Ahmed Maher  Identity Verified
Local time: 23:06
anglais vers arabe
+ ...
AUTEUR DU FIL
Thanks a million May 26, 2014

Paul,

For prompt reply, clear instructions, professionalism, and kindness, I shall say "Bravo 100%".

Thanks very much.

Ahmed


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Open Excel file in Trados Studio with Cell settings







Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »