Find and Replace coding

[Jerry]

I have a table with a name field and because of the way
it's set up, some of the names have an extra "(C)" between
the first and last name (ex. Jerry (C) Crosby).

I want to be able to strip the "(C) " from the names that
have it.

What's the best way to do that?

Thanks in advance.

Jerry

 

[Andrew L.]

This doesn't require any coding. In datasheet view of your table, position the cursor in the name
field of your first record. Then Ctrl-F (or hit the binoculars icon). Select the Replace tab.

Find what: (C)
[i.e. space-openbracket-C-closebracket-space - don't forget to include the spaces!]

Replace with:
[i.e. nothing]

Look in: [your name field]

Match: any part of field

Hit "Replace all"

Andrew

 

[Guest]

-----Original Message-----
This doesn't require any coding. In datasheet view of

your table, position the cursor in the name

field of your first record. Then Ctrl-F (or hit the

binoculars icon). Select the Replace tab.

Find what: (C)
[i.e. space-openbracket-C-closebracket-space - don't forget to include the spaces!]

Replace with:
[i.e. nothing]

Look in: [your name field]

Match: any part of field

Hit "Replace all"

Andrew

I have a table with a name field and because of the way
it's set up, some of the names have an extra "(C)" between
the first and last name (ex. Jerry (C) Crosby).

I want to be able to strip the "(C) " from the names that
have it.

I guess I wasn't clear enough. I already know how to do
what you suggest. I want something that will do it
automatically, through a query I can run from a macro.
(What I have is an existing macro that runs a query that
produces a table that is then outputted and saved as an
rtf file, so it can then be used in a mail merge document.
I want the find and replace to automatically strip
the "(C) " before the rtf file is saved.)

Hope that makes sense.

Jerry