B
Brian Smith
I have a query that contains a field which includes text from an open-ended
survey question. This is a text field and the only other field is an auto
number field. There are certain words and phrases I would like to clean up
by doing a search and replace. The problem is in some cases I do not want to
change the give word or phrase. I tried using an update query but I can't
figure out how to only change a given word/phrase (which can occur anywhere
in the text) while still keeping all of the other text as is.
For example, a person might have written:
museum, casino, zoo
I would like to change this to:
museum, Star Dog Casino, zoo
But if a person wrote:
Star Dog Casino, amusement park, zoo
I would like no changes to be made.
Is the above possible using an update query? In other words, no matter where
"casino" appears in the field have it replaced with "Star Dog Casino" unless
that term was used and if "casinos" was used I'd like to leave that as is as
well.
Trust the above makes sense.
Thanks.
Brian
survey question. This is a text field and the only other field is an auto
number field. There are certain words and phrases I would like to clean up
by doing a search and replace. The problem is in some cases I do not want to
change the give word or phrase. I tried using an update query but I can't
figure out how to only change a given word/phrase (which can occur anywhere
in the text) while still keeping all of the other text as is.
For example, a person might have written:
museum, casino, zoo
I would like to change this to:
museum, Star Dog Casino, zoo
But if a person wrote:
Star Dog Casino, amusement park, zoo
I would like no changes to be made.
Is the above possible using an update query? In other words, no matter where
"casino" appears in the field have it replaced with "Star Dog Casino" unless
that term was used and if "casinos" was used I'd like to leave that as is as
well.
Trust the above makes sense.
Thanks.
Brian