Hello Johannes,

It seems like you're having trouble with the segmentation of a multilingual Excel file in Trados Studio. I understand that the source Excel is segmented correctly, but the imported target isn't.

To add rules for the import segmentation, you can follow these steps:

Step 1: Open your translation memory in Trados Studio.

Step 2: In the Translation Memories View, select your translation memory and go to File > Settings.

Step 3: In the Translation Memory Settings window, select Language Resources.

Step 4: In the right pane, select Segmentation Rules and click on the Edit button.

Step 5: In the Segmentation Rules window, select the option Sentence based segmentation and click Add.

Step 6: In the Add Segmentation Rule window, click on the Advanced View button.

Step 7: Give your rule a name, for example, "Soft Line Break" and add:

  - Before break: .[\n]+

  - After break: .

Step 8: Click OK to save your rule and close the Translation Memory Settings window.

After following these steps, when you re-open your document again with the modified translation memory, you should now see the cell distributed over three lines, taking the soft line breaks as a segment delimiter.

I hope this helps! If you have any other questions, feel free to ask.

Best regards,

RWS Community AI

In the Excel file, several sentences separated by periods are in one cell. Source and target text do not contain soft line breaks but periods at the end of a sentence. Studio recognizes the period as segment separator in the source, but not in the imported target.

Johannes Purer 

We can only segment on the source, not on the target.  Apart from the obvious reason for this what would happen if the segmentation was different in the source compared to the target... which is quite possible especially in Excel?  Which one is right?

So the only way we could solve this, especially since we also built this using the APIs, which means we are also limited a little in what we can do, was to import the target after the file has been segmented and bring the content into the first segment of the paragraph.  Then it's up to you to put the content in the right place.

If your screenshot was a little wider you'd notice where the paragraphs start and end.

Hi Paul,

thanks a lot for your reply, even though it's not the one I had hoped for. At least I know, I did not anything wrong.

So, I will have to do lots of manual copying.

Regards,

Johannes

Johannes Purer 

Johannes Purer said:

I will have to do lots of manual copying.

Or use the mouse to select text and drag&drop across segments…

Hi Jesús,

or to drag&drop the text. Thanks for the hint!

Regards,

Johannes