Need HTML tags to be disabled from trados while Translating

Question

Hi Team, 
 I need help translating the Excel file on trados without any visible tags. I have attached the Excel file and the Trados screenshot. 
 Please help us on priority. 
 Regards, Shraddha

Daniel Hug · Accepted Answer

Might have to do with at which place Excel defines the colour, at cell level (this should work) or at character level (unlikely to work).

Jerzy Czopik · Answer

Shraddha Singh Looks like you have a full fledged html page to be translated in Excel. First of all: ask the customer to provide proper html file. If not possible, you will need to use regex and write your own html and code parser in the embedded content section of the Excel file type. You can add tag pairs there, so your and tags could completely disappear from the view in Studio. You can also hide the other codes using regex. Unfortunately it is not possible to have a single entry for this, so it cannot be done via forum. But you can be helped off-forum.

Paul · Answer

Shraddha Singh 
 you could also watch the training we provided here: 
 (240529) Working with embedded content 
 That might be helpful for you.

Daniel Hug · Answer

Shraddha Singh 
 Check this box: 
 
 This will take care of the HTML code.

Daniel Hug · Answer

Shraddha Singh 
 This has to be done in the project settings, not in File->Options. Or in the project template, if you are using one.

Daniel Hug · Answer

Changing the settings won't change the way a file already in the project is being handled. You can either delete that file (the source version), which of course will also delete all translations, or you can start a new project and make these changes at project creation: 
 
 SInce the file looks like there is a lot of stuff in it that you actually don't want to translate, I think you might like to use the Really Handy Preview Function of the project file types dialogue. Tinker around with the settings until the file looks like you want in the preview, and then move forward through the project creation wizard.

Daniel Hug · Answer

Shraddha Singh 
 Your Excel file is really messy, sorry to say that. You can skip cells "having" a certain text colour, but I am not sure how that works with cells with mixed text. Also not sure if the text colour has to be set for the cell or can be set for charaters for this filter to work.

That the code is spread out over several segments is quite unfortunate. I am almost 100% sure that this was once an XML file that got exported to Excel, making it that much harder to filter it properly. 
 This is as far as I can help you. If you manage to get the XML source of this file, and if you understand how to handle XML files ( start here for a truckload of good advice ), then you might be able to prepare this well for translation. If the Excel file is all you can get/handle, then there is a lot of manual work and messy TM entries coming your way. 
 All the best!

Jerzy Czopik · Answer

Shraddha Singh 
 Please deactivate Multilingual Excel, as this message comes from that file type.

Trados Studio > 1. Trados Studio

Need HTML tags to be disabled from trados while Translating

Top Replies