Verifying large amounts of number in a text
Thread poster: kostan

kostan
Austria
Local time: 09:44
German to English
+ ...
Apr 24, 2013

Does anybody know of a software tool/ macro that can verify/check large amounts of numbers between a ST and a TT, e.g. annual reports etc? I work with Studio 2011 which does this, but seems to miss out occasionally.

 

Attila Piróth  Identity Verified
France
Local time: 09:44
Member
English to Hungarian
+ ...
Word-Excel workaround Apr 24, 2013

1. Prepare a two-column export of the segmented translation: source on the left and target on the right. (This can be done easily even from the tmx export of the relevant part of your TM.)
2. Put the two-column table into Word, and delete everything but the numbers. For example, highlight every number and also the decimal and thousand separators (if applicable). For example, if a thousand separator comma and a decimal point are used, start with the combinations ^#.^# and ^#.^# and then add ^# This will highlight all numbers - and numbers alone. Then delete everything that is not highlighted, using Word's find and replace functions.
3. If the decimal and thousand separators between the two languages are different, (e.g., SL uses decimal point and thousand separator comma, while the target uses deciomal comma and space for thousand separator), make the necessary modifications so that the two columns use the same.
4. Copy the two columns into Excel, and use the "IDENTICAL" function to find the differences.

Best,
Attila


 

P Forgas  Identity Verified
Brazil
Local time: 04:44
Portuguese to Spanish
+ ...
ApSIC Xbench Apr 24, 2013

http://www.xbench.net/

you can find a tutorial here:

http://www.youtube.com/watch?feature=player_embedded&v=51PkGcPbJT4

Cheers

P.


 

kostan
Austria
Local time: 09:44
German to English
+ ...
TOPIC STARTER
Tks, I will check this out imm! Apr 24, 2013



 

kostan
Austria
Local time: 09:44
German to English
+ ...
TOPIC STARTER
Thank you, this is already much better than my old system! Apr 24, 2013

Attila Piróth wrote:

1. Prepare a two-column export of the segmented translation: source on the left and target on the right. (This can be done easily even from the tmx export of the relevant part of your TM.)
2. Put the two-column table into Word, and delete everything but the numbers. For example, highlight every number and also the decimal and thousand separators (if applicable). For example, if a thousand separator comma and a decimal point are used, start with the combinations ^#.^# and ^#.^# and then add ^# This will highlight all numbers - and numbers alone. Then delete everything that is not highlighted, using Word's find and replace functions.
3. If the decimal and thousand separators between the two languages are different, (e.g., SL uses decimal point and thousand separator comma, while the target uses deciomal comma and space for thousand separator), make the necessary modifications so that the two columns use the same.
4. Copy the two columns into Excel, and use the "IDENTICAL" function to find the differences.

Best,
Attila


 

Łukasz Gos-Furmankiewicz  Identity Verified
Poland
Local time: 09:44
English to Polish
+ ...
Additional precaution Apr 24, 2013

As an additional precaution, should you be unable to use automatic means of reproduction or comparison of such numbers, double-checking any numbers copied is something a client's personnel can do even without knowing the language (much less proofreaders). I'd try to reach an agreement expecting them to do so.

 


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


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

Verifying large amounts of number in a text

Advanced search







memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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