Soft line break segmentation rule for Excel files

Hi everyone,

I am fighting with making a line break in Excel a segmentation rule. While in some of the projects, it does work, in others it does not. I am aware of the solution described on below link:

noradiaz.blogspot.com/.../adding-soft-return-segmentation-rule-to.html

Unfortunately, this solution does not work in this particular case for some reason. The file type is Excel, embedded content on, TM with the above segmentation rule attached to the project and still getting the "wrong" result:

Screenshot of Trados Studio showing a segment with incorrect line break in an Excel file, with text 'Kolor: Czarny' and ' czno : Bezprzewodowe' not segmented properly.

Any other ides, please?

Thank you very much in advance.

Jan



Generated Image Alt-Text
[edited by: Trados AI at 5:08 AM (GMT 0) on 29 Feb 2024]
emoji
Parents
  • Hi 

    Yes the link you provided alongside this helpful resource,  https://m.youtube.com/watch?v=kPaHs5xjWyU should work.

    I tested to ensure I had the same scenario where in a cell I had a soft return and tags (due to formatting)

    Please see source sample and how I got it to display in Studio

    Excel spreadsheet with two cells containing text 'What are all the tags' and 'How are they being implemented'.            Trados Studio interface showing an Excel file with sheet name 'Sheet1' and same two cells of text as previous image.

    To confirm the steps I took.

    1. Edit Segment Settings by adding a new one

    2. Before Break + After Break = Anything

    Trados Studio Translation Memory Settings window with a section for Segmentation Rules and an Edit Segmentation Rule dialog box open.

    3. Advanced View and gave it a description

    4. Before Break = .[\n]+

    5. After Break = .

    Close-up of the Edit Segmentation Rule dialog box with 'Soft Return' description and regular expressions entered for 'Before break' and 'After break'.

    TIP: You do need to recreate your sdlxliff files against the amended TM.

    I hope this confirms it is possible and that I gave you enough guidance and clarity to get it working. If you still require support please confirm what are your segmentation rules?

    Lyds

    Lydia Simplicio | RWS Group

    _______
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 5:08 AM (GMT 0) on 29 Feb 2024]
Reply
  • Hi 

    Yes the link you provided alongside this helpful resource,  https://m.youtube.com/watch?v=kPaHs5xjWyU should work.

    I tested to ensure I had the same scenario where in a cell I had a soft return and tags (due to formatting)

    Please see source sample and how I got it to display in Studio

    Excel spreadsheet with two cells containing text 'What are all the tags' and 'How are they being implemented'.            Trados Studio interface showing an Excel file with sheet name 'Sheet1' and same two cells of text as previous image.

    To confirm the steps I took.

    1. Edit Segment Settings by adding a new one

    2. Before Break + After Break = Anything

    Trados Studio Translation Memory Settings window with a section for Segmentation Rules and an Edit Segmentation Rule dialog box open.

    3. Advanced View and gave it a description

    4. Before Break = .[\n]+

    5. After Break = .

    Close-up of the Edit Segmentation Rule dialog box with 'Soft Return' description and regular expressions entered for 'Before break' and 'After break'.

    TIP: You do need to recreate your sdlxliff files against the amended TM.

    I hope this confirms it is possible and that I gave you enough guidance and clarity to get it working. If you still require support please confirm what are your segmentation rules?

    Lyds

    Lydia Simplicio | RWS Group

    _______
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 5:08 AM (GMT 0) on 29 Feb 2024]
Children