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

Ana Sofia Correia  Identity Verified
Portugal
Local time: 21:03
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: 23:03
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: 21:03
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: 22:03
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: 21:03
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: 22:03
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: 21:03
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: 22:03
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: 22:03
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







TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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