Find & replace with wildcards - help

R

RAO

Dear all,

I'm urgently looking for a solution:

I've got some long word-texts and I have to edit out all the typists mistakes.

The most common mistake is words followed by a space and a colon.
(e.g. "example :" instead of "example:") (notice the space between the word
and the colon)
Is there any way of quickly fixing these with a find&replace operator?

thanks a lot in advance
Cheers!
 
T

Tom Wickerath

Hi RAO,

If you are using Access 2000 or later, one method that should work is to run
an Update query. I recommend making a backup copy of your database before
running any action query (Update, Delete, Append, etc.).

Create a new query. Dismiss the Add Table dialog. In query design view,
click on View | SQL View. Enter a SQL (Structured Query Language) statement
similar to this:

UPDATE TableName SET FieldName = Replace([FieldName]," : ",": ");

where TableName is the name of the table, and FieldName is the name of the
field.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
R

RAO

Thanks for your answer Tom,

unfortunately I'm not using Acces, only Word.

Could you come up with an equivalent solution for this in Word?

Thanks in advance!



Tom Wickerath said:
Hi RAO,

If you are using Access 2000 or later, one method that should work is to run
an Update query. I recommend making a backup copy of your database before
running any action query (Update, Delete, Append, etc.).

Create a new query. Dismiss the Add Table dialog. In query design view,
click on View | SQL View. Enter a SQL (Structured Query Language) statement
similar to this:

UPDATE TableName SET FieldName = Replace([FieldName]," : ",": ");

where TableName is the name of the table, and FieldName is the name of the
field.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

RAO said:
Dear all,

I'm urgently looking for a solution:

I've got some long word-texts and I have to edit out all the typists mistakes.

The most common mistake is words followed by a space and a colon.
(e.g. "example :" instead of "example:") (notice the space between the word
and the colon)
Is there any way of quickly fixing these with a find&replace operator?

thanks a lot in advance
Cheers!
Click to expand...
Click to expand...
 
T

Tom Wickerath

Hi Rao,

In Word, click on Edit | Replace...
Click on the More button to expand the dialog
Click on the Special button
Select "White Space" at the bottom of the list.
Add a colon.
Select "White Space" one more time.

Select the Replace textbox.
Add a colon.
Click on the Special button again.
Select Nonbreaking Space

This newsgroup is dedicated to the Microsoft Access database product. The
Microsoft website is not all that clear and may have misdirected you. In the
future, I suggest that you post Word-related questions here:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.word.docmanagement


Good Luck,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top