How to exclude <text> and </text> and from Excel files?
Thread poster: xxx2nl
xxx2nl  Identity Verified
Netherlands
Local time: 15:57
Feb 15, 2014

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)?


Direct link Reply with quote
 

Pascal Zotto  Identity Verified
Austria
Local time: 15:57
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.


Direct link Reply with quote
 

viking modena  Identity Verified
Italy
Local time: 15:57
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]


Direct link Reply with quote
 

SDL Community  Identity Verified
United Kingdom
Local time: 15:57
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


Direct link Reply with quote
 


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 »
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 »



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