Mobile menu

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

Heinrich Pesch  Identity Verified
Finland
Local time: 12:02
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: 11:02
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: 11:02
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: 10:02
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: 12:02
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: 11:02
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: 11:02
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: 11:02
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: 12:02
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: 03:02
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: 11:02
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






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »



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