This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
WFP MAC segmentation question (line breaks in Excel)
Автор темы: Jan Truper
Jan Truper Германия 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?
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Lori Cirefice Франция 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.
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
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Heinrich Pesch Финляндия 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.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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.
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.