Find & replace with wildcards - help

[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!

 

[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
__________________________________________

 

[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!

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
__________________________________________

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!

 

[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
__________________________________________