Find and Replace a Bracket with text????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
Back
Top