How to exclude <text> and </text> and from Excel files?
Thread poster: 2nl (X)
2nl (X)
2nl (X)  Identity Verified
Netherlands
Local time: 19:35
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)?


 
Pascal Zotto
Pascal Zotto  Identity Verified
Austria
Local time: 19:35
Member (2009)
Dutch to Luxembourgish
+ ...
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.


 
Luca Vaccari
Luca Vaccari  Identity Verified
Italy
Local time: 19:35
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
... See more
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]
Collapse


 
RWS Community
RWS Community
United Kingdom
Local time: 19:35
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?







CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
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 »