Mobile menu

translating numerical values, decimals etc
Thread poster: Anne Gwathmey
Anne Gwathmey  Identity Verified
Italy
Local time: 20:21
Member (2008)
Italian to English
+ ...
Jan 10, 2009

Is there a quick way to translate Italian and French numerical values to US/UK (eg: 1.000 into 1,000 and 10,00 into 10.00 respectively) in a document full of such? Or is it necessary to do one at a time? This is really going to slow me down, and I don't get paid for it!

Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 17:21
Member (2001)
English to Italian
+ ...
This article may help Jan 10, 2009

http://accurapid.com/journal/15msw.htm

Gianfranco


Direct link Reply with quote
 

KSL Berlin  Identity Verified
Portugal
Local time: 19:21
Member (2003)
German to English
+ ...
Use the right tools, maybe? Jan 10, 2009

You don't say what your working environment is. Déjà Vu X will handle these conversions automatically.

However, if you are not getting paid for this, I would simply write a short note to the client and let them deal with it. No point in giving away your efforts.


Direct link Reply with quote
 
FarkasAndras
Local time: 20:21
English to Hungarian
+ ...
good find Jan 10, 2009

gianfranco wrote:

http://accurapid.com/journal/15msw.htm

Gianfranco



Thanks for that. I didn't know that Word can reinsert "wildcard" characters in find and replace.


Direct link Reply with quote
 

trebla
Canada
Local time: 14:21
French to English
Way to convert numerical values, decimals, etc Jan 11, 2009

Yes there is. I use it all the time. Suppose you want to convert French notation into English notation. For example, numbers like 23,56 to be converted into 23.56

I assume you are working in Word. Basically, you do a Find and Replace using wildcards.

In the case above, in the FIND field, type ([0-9]),([0-9])

In the REPLACE field, type \1.\2

When using this, don't forget to check "Use Wildcards" under the MORE tab. Then go ahead and either replace all (risky) or replace one at a time. If you're dealing with a table, just block it and replace all.

What this expression says is this: FIND all numbers (0-9) followed by a comma followed by another number (0-9) and REPLACE the first number with itself (\1) followed by a period followed by the second number (\2)

Try it on a sample text.

If you like it, just look up "Using WILDCARDS in Word". There are a number of sites that deal with it. YOu can learn all kinds of things using this technique. Very powerful!


Direct link Reply with quote
 

Marijke Singer  Identity Verified
United Kingdom
Local time: 19:21
Dutch to English
+ ...
Another more basic way is to use colours Jan 11, 2009

For example
Replace 0, by 0. but red instead of the original colour
Replace 1, by 1. but red instead of the original colour
Etc. (to cover all the digits between 0 and 9)

Then you search for
0. in the original colour and replace it by 0,
1. in the original colour and replace it by 0,
Etc. (to cover all the digits between 0 and 9)

Change the red for the original font colour (I have used red but you can set it to whatever colour that is not used in your original document; you can search for only colour in Word).

The above method can be applied to the whole document (change all) without mistakes being made.


Direct link Reply with quote
 
FarkasAndras
Local time: 20:21
English to Hungarian
+ ...
I'd not do this Jan 11, 2009

Marijke Singer wrote:

For example
Replace 0, by 0. but red instead of the original colour
Replace 1, by 1. but red instead of the original colour
Etc. (to cover all the digits between 0 and 9)

Then you search for
0. in the original colour and replace it by 0,
1. in the original colour and replace it by 0,
Etc. (to cover all the digits between 0 and 9)

Change the red for the original font colour (I have used red but you can set it to whatever colour that is not used in your original document; you can search for only colour in Word).

The above method can be applied to the whole document (change all) without mistakes being made.



Numbers are followed by a comma or a sentence closing full stop fairly often. You wouldn't want those to get caught in the crossfire with replace all, so it's better to go with the longish formula that makes sure only commas and dots between two digits are affected.
Also, the ([0-9],) to \1. does the exact same thing as what you describe, only in one step instead of ten.

In case a sort of cross-replacement is needed, I'd use some other symbol, say ***dot*** instead of colours but that's a minor point.


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 »

translating numerical values, decimals etc

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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