Replacing "\n" in an Excel file with a tag - Trados 2019

I have an Excel file where soft returns are coded as text (\n). I want to convert them to tags to get them out of my way. They often appear after segment-ending punctuation (period, exclamation point, question mark) without a space between the two, resulting in segments that can contain multiple sentences.

Source text in Excel and resulting segment in the converted file: Blah blah blah.\nText text text.

I would like:

Segment 1: Blah blah blah.

Segment 2: [tag]Text text text.


Segment 1: Blah blah blah.[tag]

Segmeng2: Text text text.

Working on a primitive level, I have prepped the Excel files by adding a space (search for ".\n" replace with ". \n" (etc. for ? and !) to get the segmentation right, but I really would like tags instead of \n -- they're distracting and make spell checking laborious (every "nText" has to be dealt with).

It would be wonderful to replace them with a tag and get the segmentation to work the way I want it to. The solution seems to lie in defining a tag in Embedded Content in the Excel file type and possibly also a segmentation rule. "\\n" doesn't work for me, but my knowledge of regex is pretty limited so any number of things could be wrong or missing.

Does anyone know how to go about configuring this?

Thanks in advance!

Parents Reply
  • Everything is going swimmingly, Paul, except... I have a tag for a variable at the end of a segment that is not showing up in Editor that I need to be able to interact with it for syntax reasons. (I'd actually just as soon see all my tags to be on the safe side. I don't really understand the benefit of this behavior of not having them visible.)

    Source text in Excel: Blob de {%Ingredient}

    Source segment appearance in Editor: Blob de

    Target segment appearance in Editor: Blob

    Target text in Excel: Blob {%Ingredient}

    What I want in Excel: {%Ingredient} Blob

    What can I do to display all my tags?