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

Heinrich Pesch  Identity Verified
Finland
Local time: 14:50
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: 13:50
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: 13:50
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: 12:50
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: 14:50
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: 13:50
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: 13:50
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: 13:50
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: 14:50
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: 06:50
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: 13:50
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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

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



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