Applying character limit when translating Excel files in Tag Editor
Thread poster: Ana Sofia Correia

Ana Sofia Correia  Identity Verified
Portugal
Local time: 16:49
Member (2008)
English to Portuguese
Dec 30, 2008

Hello to you all!

This is my first post here on Proz forums, I’ll try to do my best to be specific... I hope that you can help me. I am a recent user of Tag Editor and I only know the very basics (Open – Translate – Save)...

I want to translate excel (Office 2007) files on Tag Editor (Trados 2007). The files are like this: Column A > Original text ; Column B > Translation.

And Column B has a character limit of 70 characters. My question is: When opening the Excel file in Tag Editor, does it automatically “apply” the character limit to the target segment or do I have to do it manually? If so, is it possible to do that and how do I do that?

Thank you in advance for your help!

Ana Sofia Correia


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 18:49
Member (2003)
Finnish to German
+ ...
Don't think so Dec 30, 2008

At the bottome of the TE screen you see at which position the cursor is. Stop at position 70 (make the window broad enough).
Regards
Heinrich


Direct link Reply with quote
 

Ana Sofia Correia  Identity Verified
Portugal
Local time: 16:49
Member (2008)
English to Portuguese
TOPIC STARTER
Thank you Dec 30, 2008

Thank you Heinrich.

It would be great if TE had that option...

I wish you a Happy 2009!



Ana


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 17:49
Member (2003)
Polish to German
+ ...
You can check the length limit afterwards Dec 30, 2008

Follow Heinrich's advice and after you're finished use the QA Checker to proof, if you did not exceed the limit.

Direct link Reply with quote
 

Ana Sofia Correia  Identity Verified
Portugal
Local time: 16:49
Member (2008)
English to Portuguese
TOPIC STARTER
QA checker? Dec 30, 2008

Thank you Jerzy.

But I thought that QA checker only looked for untranslated segments... (As I said, I am a very recent user of TE...). So, it can also be used to see the number of characters per segment?

Happy 2009!



Ana


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 17:49
Member (2003)
Polish to German
+ ...
Not only for that Dec 30, 2008

QA Checker has a lot of possibillities.
Try it out - check Tageditor help for details.


Direct link Reply with quote
 

Ana Sofia Correia  Identity Verified
Portugal
Local time: 16:49
Member (2008)
English to Portuguese
TOPIC STARTER
Many thanks and Happy 2008! Dec 30, 2008

I'll do as you say.

Many thanks to Heinrich and Jerzy!

Happy 2009!

Ana


Direct link Reply with quote
 

Vito Smolej
Germany
Local time: 17:49
Member (2004)
English to Slovenian
+ ...
whatever you'll do on the fly.... Dec 31, 2008

....And Column B has a character limit of 70 characters. My question is: When opening the Excel file in Tag Editor, does it automatically “apply” the character limit to the target segment or do I have to do it manually?...

... , you will eventually have to check it all once more time, when things are finished. And this is pretty easy in Excel, anyhow much easier than watching the character counts each tim you are about to end a segment in TE. You just need additional column with a formula If(Len(B1)>70;"XXX";"") propagated through all the lines. The same trick can be used for

i) terminating periods
ii) Uppercase starts of strings
...

Regards

Vito

[Edited at 2008-12-31 07:31 GMT]


Direct link Reply with quote
 

Grzegorz Gryc  Identity Verified
Local time: 17:49
French to Polish
+ ...
QA checker... Swordfish... Dec 31, 2008

Vito Smolej wrote:

....And Column B has a character limit of 70 characters. My question is: When opening the Excel file in Tag Editor, does it automatically “apply” the character limit to the target segment or do I have to do it manually?...

Interactively, no way.

... , you will eventually have to check it all once more time, when things are finished. And this is pretty easy in Excel, anyhow much easier than watching the character counts each tim you are about to end a segment in TE. You just need additional column with a formula If(Len(B1)>70;"XXX";"") propagated through all the lines.


For this purpose you can use directly the QA checker in Tag Editor.
Tools > Plug-ins
Select SDL Trados QA Checker or SDL Trados QA Checker 2.0
Click Properties.
Segment verification > Check for segments exceeeding the following character count

The same trick can be used for

i) terminating periods
ii) Uppercase starts of strings


The same, Ponctuation tab.


BTW.
If you want to control the text length as you type, try Swordfish.
http://www.maxprograms.com

Tasks > Set Target Text Length Limits

It doesn't work in the way you expect (i.e. the text limits are relative not absolute)but:
1) it shows the number of chars (just like TagEditor, in the status line botton, on the right).
2) warns if the string length exceeds the source length (displayed in red)

Swordfish open TTX files, you can try it 30 days.

Cheers
GG


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 »

Applying character limit when translating Excel files in Tag Editor

Advanced search







WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



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