WFP MAC segmentation question (line breaks in Excel)
Автор темы: Jan Truper
Jan Truper
Jan Truper  Identity Verified
Германия
Local time: 12:05
английский => немецкий
Jan 17, 2012

Setup: WFP (2.4.4 / Build id: 20111209-0930) on a Mac (10.7.2)

I'm dealing with an .xlxs file; some cells contain terms divided by line breaks.
When opening the file in WFP, I'd like each of these terms to appear in an individual segment (currently they are lumped together in one segment with a bunch of tags between them).

(How) can this be accomplished?


 
Lori Cirefice
Lori Cirefice  Identity Verified
Франция
Local time: 12:05
французский => английский
find and replace Jan 17, 2012

I think the best way to achieve what you want is to remove those line breaks from the xlsx file before importing to WFP.

Use excel FR to find ALT + 010 (with the cursor in the "find" field, hold down the 'Alt' button and type the numbers '010'. The field will remain blank, it looks like nothing happened, but in fact, it's there – just blank).

Replace with something like "space" + ":" which should make wordfast recognize those : as the end of a segment.

... See more
I think the best way to achieve what you want is to remove those line breaks from the xlsx file before importing to WFP.

Use excel FR to find ALT + 010 (with the cursor in the "find" field, hold down the 'Alt' button and type the numbers '010'. The field will remain blank, it looks like nothing happened, but in fact, it's there – just blank).

Replace with something like "space" + ":" which should make wordfast recognize those : as the end of a segment.

After translation, you will need to perform the opposite operation to get the cells back the way they should be with, without ":"

Do a short test on a few lines to see if it works for you before doing the operation on a *copy* of your original file.
Collapse


 
Heinrich Pesch
Heinrich Pesch  Identity Verified
Финляндия
Local time: 13:05
Член ProZ.com c 2003
финский => немецкий
+ ...
I had this problem earlier Jan 17, 2012

But more recently WFP does separate these cases like it should. I don't know why. Perhaps you should re-install in order to get the initial settings back.

 


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


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

WFP MAC segmentation question (line breaks in Excel)







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 »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »