Mobile menu

Make all decimal points into decimal commas?
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Finland
Local time: 18:56
Member (2003)
Finnish to German
+ ...
Jul 27, 2004

Is there a possibility (command, macro) to change all decimal points into commas. Something like replacing the point, if its between two numerals?
Would be great for my ungoing project.


Direct link Reply with quote
 

jmadsen  Identity Verified
Local time: 17:56
I usually use Find and replace in Word Jul 27, 2004

Find: ^#.^# and replace with ^#,^# (^# denotes any digit).
Though I wouldn't recommend using "Replace all".
It takes time, but maybe there's a smarter way.

A suggestion
Jørgen


Direct link Reply with quote
 
RobinB  Identity Verified
Germany
Local time: 17:56
German to English
Check out Carob Jul 27, 2004

which is Robin Stocks's blog, at:

http://www.words-worth.de/robin/

where he gives a macro for the other way round (comma to point). I presume you can invert it.

HTH,
RobinB


Direct link Reply with quote
 

Graciela Carlyle  Identity Verified
United Kingdom
Local time: 16:56
English to Spanish
+ ...
check wordfast group Jul 27, 2004

Heinrich Pesch wrote:

Is there a possibility (command, macro) to change all decimal points into commas. Something like replacing the point, if its between two numerals?
Would be great for my ungoing project.


Hi Heinrich,

There were some macros posted in wordfast yahoo group exactly for that purpose a few weeks ago.

Cheers,
Grace.


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 18:56
Member (2003)
Finnish to German
+ ...
TOPIC STARTER
Thank you all! Jul 28, 2004

That will save me much time.
Regards

But Word won't do it. It says ^# does not do as a wildcard, even when I search for [0-9].[0-9]

Strange!

Heinrich

[Edited at 2004-07-28 08:15]


Direct link Reply with quote
 

Fernando Toledo  Identity Verified
Germany
Local time: 17:56
Member (2005)
German to Spanish
That will change not only decimal comas Jul 28, 2004

Hi,

the problem is that not only decimals comas will be convert into points, so you can lost a lot of millions

CU

Toledo


Jørgen Madsen wrote:

Find: ^#.^# and replace with ^#,^# (^# denotes any digit).
Though I wouldn't recommend using "Replace all".
It takes time, but maybe there's a smarter way.

A suggestion
Jørgen


Direct link Reply with quote
 
Charlotte Blank  Identity Verified
Local time: 17:56
Czech to German
+ ...
Try this one Jul 28, 2004

CTRL H, then:
([0-9]).([0-9])
Replace with
1,2 (this should have been backslash1,backslash2)
Use wildcards

I got this hint from a colleague here at proz some time ago. It is working marvellously, at least for me:) But be careful with English millions and billions...

Charlotte

[Edited at 2004-07-28 13:59]


Direct link Reply with quote
 
rstocks
Local time: 17:56
German to English
There are two different sorts of wildcard Jul 28, 2004

Heinrich Pesch wrote:

But Word won\'t do it. It says ^# does not do as a wildcard, even when I search for [0-9].[0-9]

[Edited at 2004-07-28 08:15]


^# finds any number in the normal Find dialogue with the \'Use wildcards\' option switched OFF.

Use [0-9] instead of ^# when searching with the \'Use wildcards\' option.

You can\'t mix the two.

Robin


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 18:56
Member (2003)
Finnish to German
+ ...
TOPIC STARTER
Too difficult after all Jul 28, 2004

Word will not do it, and the document contains so many other occations, where the point between numbers should remain, that I could not do it for all automatically, even if it worked.
I'll leave it as it is or do it manually.


Direct link Reply with quote
 

Jaime Oriard  Identity Verified
Mexico
Local time: 10:56
Member (2005)
English to Spanish
+ ...
Include a longer string Aug 16, 2004

Instead of just typing ^#.^# in the search box, include all the decimal places and the following space/comma/period/^p/etc. This is still a long process since you have to run the search several times for the different options, but still faster than doing it manually over a long document.

The string to replace a period for a comma in a string like this:

Max. Length: 786.50 mm;

would be:

Search for:
([0-9]),([0-9][0-9] )

Replace with:
\1,\2

Notes: Wildcards option must be selected.
This expression will change all instances of a number with two digits fillowed by a space


Direct link Reply with quote
 

lien
Netherlands
Local time: 17:56
English to French
+ ...
good links Sep 7, 2004

Everything explained here :

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


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 »

Make all decimal points into decimal commas?

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 »
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 »



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