|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 29th, 2009, 01:22 PM
posted to microsoft.public.word.newusers
|
|||
|
|||
Find and Replace
I have a database which has information about a person. One of the field is
contact number which is like 123.456.7890 I want to change that contact number to 123-456-7890. I cant use find and replace function to find a "." and replace it with "-" as some other fields like email id can have "." in them and I want to replace ". " between contact numbers only. eg Punit Arekar MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ... 
|
|
#2
November 29th, 2009, 01:37 PM
posted to microsoft.public.word.newusers
|
|||
|
|||
|
Find and Replace
With the wildcard option set
http://www.gmayor.com/replace_using_wildcards.htm Replace ([0-9]{3}).([0-9]{3}).([0-0]{4}) with \1-\2-\3 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org punitarekar wrote: I have a database which has information about a person. One of the field is contact number which is like 123.456.7890 I want to change that contact number to 123-456-7890. I cant use find and replace function to find a "." and replace it with "-" as some other fields like email id can have "." in them and I want to replace ". " between contact numbers only. eg Punit Arekar MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ...
|
|
#3
November 29th, 2009, 02:03 PM
posted to microsoft.public.word.newusers
|
|||
|
|||
|
Find and Replace
Oops - that should be
([0-9]{3}).([0-9]{3}).([0-9]{4}) -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Graham Mayor wrote: With the wildcard option set http://www.gmayor.com/replace_using_wildcards.htm Replace ([0-9]{3}).([0-9]{3}).([0-0]{4}) with \1-\2-\3 punitarekar wrote: I have a database which has information about a person. One of the field is contact number which is like 123.456.7890 I want to change that contact number to 123-456-7890. I cant use find and replace function to find a "." and replace it with "-" as some other fields like email id can have "." in them and I want to replace ". " between contact numbers only. eg Punit Arekar MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ...
|
|
#4
November 29th, 2009, 08:17 PM
posted to microsoft.public.word.newusers
|
|||
|
|||
|
Find and Replace
Thanx that helped ...
Graham Mayor wrote: Oops - that should be ([0-9]{3}).([0-9]{3}).([0-9]{4}) With the wildcard option set http://www.gmayor.com/replace_using_wildcards.htm Replace [quoted text clipped - 19 lines] Can somebody help in this case? Thanx ... -- Warm Regards, Punit Arekar Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...neral/200911/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
