Hard return in Excel with SDLX
Thread poster: Jean-S�bastien FEREY
Jean-S�bastien FEREY
English to French
Jan 8, 2007

Hi all,

This is my first post on proz.

I currently have a project for a client (Excel) that is quite big in term of volume and I would like to use SDLX to transalte the Excel files.

My main concern is some cells have their text divided in several lines, each of them separated by a hard return carriage (Alt+Enter).

I tried to import the files with my SDLX segmentation rule set to paragraph, but it imports them lines by lines. Let's say a cell in the Excel files has 6 lines, all separated by a hard return carriage; the result I have with SDLX is 6 separated lines instead of a paragraph.

Does anybody know how I could create a segmentation rule that would alllow me to import each cell as a separated paragraph of text?

Thanks in advance for your help.

Seb


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 04:39
Member (2003)
Finnish to German
+ ...
Did you try to export the cells to Word first? Jan 8, 2007

I never try to translate straight from Excel, instead I copy the cells to Word. When copying the translation bach into Excel I found it useful to use Open Office instead of excel, because it is more compatible with Word-files and you won't get any additional cells where there are linebreaks in the text.
Cheers
Heinrich


Direct link Reply with quote
 
Marta Fernandez-Suarez  Identity Verified
United Kingdom
Local time: 02:39
English to Spanish
I think there is no problem Jan 9, 2007

Hello Jéan

I've just done a test with a mini-Excell file in which I inserted two lines in one cell (by doing Alt Enter) and there is no problem. You do see two separate lines in the bilingual itd, but when you do a preview of the translated text, you'll see that the format is the same: two lines in one cell.

Please, write to me directly if you want to ask me my settings.


Kind regards,

Marta


Direct link Reply with quote
 


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


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

Hard return in Excel with SDLX

Advanced search







PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

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 »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search