Find and replace: invert symbol and number

[Robin]

Hi all

I'm a translator and frequently need to reverse a symbol and a number.
I'd like to be able to do it automatically. The most obvious (but not
the only) case is currency. My source languages write 10$ or 10€ or
10£ ( or sometimes 10 $, 10 €, 10 £). I'm looking to make these $10,
€10, £10.

My technical knowledge is minimal., I'm an IT user, not a pro. I know
about macros but I never installed one other than an automatic
self-install. Can it be done with the more sophisticated aspects of
Find and Replace?

All help appreciated.

Robin

 

[Doug Robbins]

See the article "Finding and replacing characters using wildcards" at:

http://word.mvps.org/FAQs/General/UsingWildcards.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Robert]

Hi all

I'm a translator and frequently need to reverse a symbol and a number.
I'd like to be able to do it automatically. The most obvious (but not
the only) case is currency. My source languages write 10$ or 10€ or
10£ ( or sometimes 10 $, 10 €, 10 £). I'm looking to make these $10,
€10, £10.

My technical knowledge is minimal., I'm an IT user, not a pro. I know
about macros but I never installed one other than an automatic
self-install. Can it be done with the more sophisticated aspects of
Find and Replace?

All help appreciated.

Robin

Greetings--
You must first turn generic characters on in the Find / Replace dialog.

Then the following Find / Replace strings

([0-9]@)($)

\2\1

will replace 10$ with $10 (and any other such non-decimal figure)

--------------------

([0-9]@)( )(£)

\3\1

will replace 10 £ (space character in between) with £10 (no space character
in between)

--------------------

([0-9]@.[0-9]@)( )(£)

\3\1

will replace such figures as 15698.58 £ (decimal figure with space
character in between the pound sterling sign and the figure itself) with
£15698.58 (no space character in between)

 

[Robin]

Great. Thanks. The only problem I had with your advice was "generic
characters". Then I figured it was "wild cards" in my dialog box.
(Word 2002).

Robin

Hi all

I'm a translator and frequently need to reverse a symbol and a number.
I'd like to be able to do it automatically. The most obvious (but not
the only) case is currency. My source languages write 10$ or 10€ or
10£ ( or sometimes 10 $, 10 €, 10 £). I'm looking to make these $10,
€10, £10.

My technical knowledge is minimal., I'm an IT user, not a pro. I know
about macros but I never installed one other than an automatic
self-install. Can it be done with the more sophisticated aspects of
Find and Replace?

All help appreciated.

Robin

Greetings--
You must first turn generic characters on in the Find / Replace dialog.

Then the following Find / Replace strings

([0-9]@)($)

\2\1

will replace 10$ with $10 (and any other such non-decimal figure)

--------------------

([0-9]@)( )(£)

\3\1

will replace 10 £ (space character in between) with £10 (no space character
in between)

--------------------

([0-9]@.[0-9]@)( )(£)

\3\1

will replace such figures as 15698.58 £ (decimal figure with space
character in between the pound sterling sign and the figure itself) with
£15698.58 (no space character in between)