Treatment of multi-line entries in Excel file
Thread poster: Neil Coffey

Neil Coffey  Identity Verified
United Kingdom
Local time: 05:58
French to English
+ ...
Jan 6, 2015

I'm translating an Excel file in TRADOS that had multi-line entries (i.e. ones with newlines in them, as achieved by pressing SHIFT+ENTER). When the file is imported into TRADOS, I was thinking that separate lines inside a given cell would be split into separate translation units, but this hasn't happened. I guess I'll live with it for this document unless there's a way to retrospectively re-split the items, but for future reference, is there some setting I should be using when initially setting up the project so that cells containing newlines are split into separate TUs at each newline?

(Apologies if this is a silly question: I confess I don't actually use TRADOS that much -- only for specific projects such as this one...)

[Edited at 2015-01-06 23:24 GMT]

Direct link Reply with quote

SDL Community  Identity Verified
United Kingdom
Local time: 06:58
Add a new segmentation rule... Jan 7, 2015

... to your TM to break on the soft return.

So go to the TM Maintenance View, open your TM so it's in the list in the left handside. Then right-click and select Settings. Now click on Language Resources and then Segmentation Rules on the right. Edit these rules and add a new rule called "Soft Break", or whatever you like. Then go to the Advanced View and use these two expressions:

Before Break

After Break

Now when you prepare your file with this TM selected you will find each line is separate.



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 »

Treatment of multi-line entries in Excel file

Advanced search
You’re a freelance translator? helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search