Find and Replace a Bracket with text????

L

LP24

I'm trying to clean up an Access 2002 database of 185,000 entries, where one
field contains information that ends with the following three characters: [In

I've tried to find and replace the bracket, but Access thinks it's part of a
string. How can I locate these three characters, and remove them from each
entry?

Thanks,
Peter
 
J

John Vinson

I'm trying to clean up an Access 2002 database of 185,000 entries, where one
field contains information that ends with the following three characters: [In

I've tried to find and replace the bracket, but Access thinks it's part of a
string. How can I locate these three characters, and remove them from each
entry?

Thanks,
Peter
Click to expand...

Run an Update query updating the field to

Replace([fieldname], "[In", "")

To make this somewhat more efficient, use a criterion of

LIKE "*[[[]In"

enclosing the left square bracket IN square brackets so it takes it
literally.

John W. Vinson[MVP]
 
Top