How to exclude <text> and </text> and from Excel files?
Thread poster: 2nl (X)

2nl (X)  Identity Verified
Netherlands
Local time: 13:05
Feb 15, 2014

I have to translate an Excel file with software strings. Every string is surrounded by <text&gt and </text&gt and placed in its own table cell.

How can I let Studio 2014 only show the text that has to be translated (I don't want to see <text&gt and </text&gt or tags representing them)?


 

Pascal Zotto  Identity Verified
Austria
Local time: 13:05
Member (2009)
Dutch to Letzeburgesch
+ ...
You find a solution here Feb 15, 2014

Hi,

Please check this link, it's what you are looking for:


http://www.proz.com/forum/sdl_trados_support/234694-trados_2011_new_segmentation_rule-page3.html

You then only need to either enter them as single or pair tags and exclude them from the strings with the according option.


 

viking modena  Identity Verified
Italy
Local time: 13:05
Member (2012)
Swedish to Italian
+ ...
Seach replace before and after Feb 15, 2014

I have not had this problem with Studio yet, but if it was WordWorkbench or TagEditor, I would do this:
1) search "text" and replace with e.g. *_ (= that is asterisk and blank, so the next word is not attached), and "/text" with _$ (blank and dollar) or any other thing that Trados jumps over and does not count (e.g. 111, 222, 333).
You will still see the tags, but they won't have any impact DURING translation as the content of your cells is separated from the tags.
2) When you are done, you simply search/replace backwards.
Be sure that you replace to the right capital letter format, when you deliver back. Else the numerical system that is supposed to read back these things might react negatively.
Regards

PS. I had to use quotation marks instead of < >, because they disappear there in ProZ

[Edited at 2014-02-15 10:01 GMT]


 

SDL Community  Identity Verified
United Kingdom
Local time: 13:05
English
Just hide them... Feb 15, 2014

2nl wrote:

I have to translate an Excel file with software strings. Every string is surrounded by <text> and </text> and placed in its own table cell.

How can I let Studio 2014 only show the text that has to be translated (I don't want to see <text> and </text> or tags representing them)?


... it’s fairly simple to do, especially if you only have these tags. the process is explained here: http://wp.me/p2xDjK-sO

So for your example you just need one rule. Add a translatable tag pair as follows:

Start tag
<text>

End tag
</text>

The article explains where to place this.

Regards

Paul


 


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


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

How to exclude <text> and </text> and from Excel files?

Advanced search







PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search