Technical forums » Trados support »
Open Excel file in Trados Studio with Cell settings
Thread poster: Ahmed Maher
Ahmed Maher
Ahmed Maher  Identity Verified
Local time: 08:05
English to Arabic
+ ...
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
United Kingdom
Local time: 07:05
English
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: 08:05
English to Arabic
+ ...
TOPIC STARTER
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:

Moderator(s) of this forum
Natalie[Call to this topic]
Myron Netchypor[Call to this topic]
Marco Ramón[Call to this topic]
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Open Excel file in Trados Studio with Cell settings







CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »