Is there a way to exclude certain codes in an Excel file from translation in SDL Trados Studio?
Thread poster: Jonathan Fray

Jonathan Fray
United States
Local time: 06:48
Member (2010)
Portuguese to English
+ ...
Jul 23, 2012

Hi!

I would like to know if anyone knows if there is a way to customize SDL Trados Studio's file settings to treat certain codes in an Excel file as tags or non-translatable.

For example in an Excel file there is: two 35@DG@ helix flutes and two 37@DG@ helix flutes
and
@TAB@The unique radius geometry of the solid FEEDMILL

Is there a way to configure SDL Trados Studio to either not import the text around @...@ as translatable or teat them as tags?

In the excel file these codes are actually enclosed by greater than and lesser than signals however i haven't put these in here becuase they dissapear in this post.

The text is full of these and I would like to know if would be a way to do this so that it would be easier to work and not dirty up the TM.

Thanks!
Jon


 

SDL Community  Identity Verified
United Kingdom
Local time: 12:48
English
using Studio 2011 SP2... Jul 23, 2012

... yes there is. What version do you have?

Regards

Paul


 

Jonathan Fray
United States
Local time: 06:48
Member (2010)
Portuguese to English
+ ...
TOPIC STARTER
Yes, Studio 2011 SP2 Jul 23, 2012

Thank you very much for your time Paul... It would be in Studio 2011 SP2. I tried for quite awhile under Embedded Content in the file types settings in Studio but couldn't get it to work.
I don't know really how to set all those tag definition rules and haven't really found any material that explains this well even though I'm SDL certified...icon_smile.gif

Once again, I appreciate very much your time!


 

SDL Community  Identity Verified
United Kingdom
Local time: 12:48
English
Great... Jul 23, 2012

... in this case if your files are exactly as shown in your first post then do the following based on this sheet (my guess at what you meant):


In the embedded content settings:


1. Enable it
2. Select Cell
3. Add a couple of placeholders as shown

Save it and open your file. Looks like this for me with the TAB now being moved out of view as it was at the start, and the inline <DG> showing as tags:


Is this what you meant?

Regards

Paul

ps. You do the angle brackets in here with & l t ; for the left and & g t ; for the right... without the spacesicon_wink.gif


 

FarkasAndras  Identity Verified
Local time: 12:48
English to Hungarian
+ ...
> Jul 24, 2012

SDL Support wrote:

ps. You do the angle brackets in here with & l t ; for the left and & g t ; for the right... without the spacesicon_wink.gif

This is hardly of any importance, but when you want to show people how to use character entities, you can just type &amp;lt;, which will show up as &lt;.
(Now, in order to show you that, I had to type &amp;amp;lt; ... this loop is never gonna end.)

[Edited at 2012-07-24 09:13 GMT]


 

SDL Community  Identity Verified
United Kingdom
Local time: 12:48
English
&lt;b&gt;:-)&lt;\b&gt; Jul 24, 2012

FarkasAndras wrote:

SDL Support wrote:

ps. You do the angle brackets in here with & l t ; for the left and & g t ; for the right... without the spacesicon_wink.gif

This is hardly of any importance, but when you want to show people how to use character entities, you can just type &lt;, which will show up as <.
(Now, in order to show you that, I had to type &amp;lt; ... this loop is never gonna end.)

[Edited at 2012-07-24 09:13 GMT]


 

FarkasAndras  Identity Verified
Local time: 12:48
English to Hungarian
+ ...
Quote Jul 24, 2012

You see, when you quote a post like you did there with mine, character entities get translated into characters again, so you have to add another amp; to my to &amp;amp;lt;

I told you this is never gonna end.


 

Jonathan Fray
United States
Local time: 06:48
Member (2010)
Portuguese to English
+ ...
TOPIC STARTER
Great! It worked... Jul 24, 2012

Thanks Paul for your detailed explanation. I was able to do it.

Actually the codes were <@TAB@>, ect.



[Edited at 2012-07-24 15:24 GMT]


 


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


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

Is there a way to exclude certain codes in an Excel file from translation in SDL Trados Studio?

Advanced search







BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

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