Search and replace string within fields across table

[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

 

[Arvin Meyer [MVP]]

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".

 

[Jeff Boyce]

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.

 

[John]

Single field.

Regards

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.

 

[Jeff Boyce]

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.