Make all decimal points into decimal commas?
Thread poster: Heinrich Pesch
Heinrich Pesch
Heinrich Pesch  Identity Verified
Finland
Local time: 19:39
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.


 
Jørgen Madsen
Jørgen Madsen  Identity Verified
Local time: 18:39
English to Danish
+ ...
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


 
RobinB
RobinB  Identity Verified
United States
Local time: 11:39
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


 
Graciela Carlyle
Graciela Carlyle  Identity Verified
United Kingdom
Local time: 17:39
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.


 
Heinrich Pesch
Heinrich Pesch  Identity Verified
Finland
Local time: 19:39
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]


 
Fernando Toledo
Fernando Toledo  Identity Verified
Spain
Local time: 18:39
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


 
Charlotte Blank
Charlotte Blank  Identity Verified
Germany
Local time: 18:39
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]


 
rstocks
rstocks
Local time: 18:39
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


 
Heinrich Pesch
Heinrich Pesch  Identity Verified
Finland
Local time: 19:39
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.


 
Jaime Oriard
Jaime Oriard  Identity Verified
Mexico
Local time: 10:39
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] )
... See more
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
Collapse


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

Everything explained here :

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


 


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?






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 »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »