Search and replace string within fields across table

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I need to find a substring in a field across the whole table and replace it
with another substring. Is there such a find/replace feature available in
access?

Thanks

Regards
 
Sure, if you don't need to do it on a regular basis, it's probably easiest
to do it with the built-in Find/Replace in Access:

Edit >>> Replace

and fill in the strings. Then change to "Any part of the field".
 
John

Are you saying that the substring in question could be in ANY field across
the whole table? Or that you want to find a particular substring in a
SINGLE field in a table?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Single field.

Regards

Jeff Boyce said:
John

Are you saying that the substring in question could be in ANY field across
the whole table? Or that you want to find a particular substring in a
SINGLE field in a table?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
Click to expand...
 
See Arvin's response...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top