Technical forums » Trados support »
Creating a tag for newline (\n) and pipe (|) for Excel file
Thread poster: Catherine Dexter
Catherine Dexter
Catherine Dexter
Spain
Spanish to English
Apr 21, 2022

I'm translating an xlsx file that contains lots of newlines as backslash followed by n (\n). I'd like to convert them to tags to get them out of my way, but I don't understand regex well enough to do it.

I'd also like the segmentation to work so that a period, question mark or exclamation point right before \n but with no space after it (for example: .\n) ends the segment. (If \n appears between two words in a sentence, I don't want a break.)

I've gotten far enough in... See more
I'm translating an xlsx file that contains lots of newlines as backslash followed by n (\n). I'd like to convert them to tags to get them out of my way, but I don't understand regex well enough to do it.

I'd also like the segmentation to work so that a period, question mark or exclamation point right before \n but with no space after it (for example: .\n) ends the segment. (If \n appears between two words in a sentence, I don't want a break.)

I've gotten far enough in researching to see that I need to define \n as a placeholder tag in Embedded Content and that \n is a control character, but I can't get anything to work (escaping out with a backslash before the backslash in \\n) and have no idea how to work with Advanced Settings or if they're involved in any way.

I also have pipes (|) that it would be nice to replace with tags, but it's not as critical since the pipe doesn't interfere with spell-checking.

Anyone know how to do this?

Thanks in advance!

[Edited at 2022-04-21 10:58 GMT]

[Edited at 2022-04-21 11:07 GMT]

[Edited at 2022-04-21 11:25 GMT] ▲ Collapse
 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 09:33
English to Russian
The processed file doesn't look like the preview Apr 22, 2022

because you have to re-import your source files after all the changes that you applied to your segmentation rules. You have to re-build both target and source sdlxliff files.
Switch to the source mode, remove the existing sdlxliff files (this action will remove both source and target sdlxliff files), drag and drop your source files again to the same project and run the 'Prepare without project TM' batch task. You could achieve the desired result not because you created a new TM, but becau... See more
because you have to re-import your source files after all the changes that you applied to your segmentation rules. You have to re-build both target and source sdlxliff files.
Switch to the source mode, remove the existing sdlxliff files (this action will remove both source and target sdlxliff files), drag and drop your source files again to the same project and run the 'Prepare without project TM' batch task. You could achieve the desired result not because you created a new TM, but because you created new sdlxliff files. Actually you don't need to create a new project from scratch. You only need to re-create sdlxliff files, no matter whether you create a new TM or not. You can find this information at RWS forum — an RWS staff member Lydia Simplicio (formerly known as Steven) mentioned it in his/her reply:
Recreate your sdlxliff files against the amended TM


[Edited at 2022-04-23 14:48 GMT] ▲ Collapse
 


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

Moderator(s) of this forum
Natalie[Call to this topic]
Myron Netchypor[Call to this topic]
Marco Ramón[Call to this topic]
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Creating a tag for newline (\n) and pipe (|) for Excel file







Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »