How to Find & Replace a Particular Phrase in Access 2003

L

lbohen

I have a database of over 10K records, each has the following phrase that I
want to change from

border="0" /><center><strong><font color="#990000">Free USA Shipping, Orders
$50 or more!</font></strong></center></p><p>

to

border="0" />

There must be a character that is preventing the finding of the phrase as
the search does NOT find it and I know it is in each record.

How do I find & replace the phrase?
 
L

Larry B

It appears as if you have used Find and Replace. Have you tried an update
query?
Make a backup of your table first!!!!
In the query design view add the table containing your field.
In the query menu, Query menu, change the query type to update.
Add the field you want to change.
As criteria enter the expression you are searching for, e.g.:
 Like "border="0" /><center><strong><font color="#990000">Free USA Shipping,
Orders  $50 or more!</font></strong></center></p><p>"

As the value to up date to enter what you want.
Make sure you have made a backup of your table before you run the query.

It may be that the quotes in your expression are, or will, mess up Access
being able to correctly do what you wish.  You may need to play around with
replacing single quotes for double quotes. Since double quotes are how access
denotes the beginning or end of a string, expressions with double quotes in
them can be problematic.

Thanks John and Frank; The phrase that I want to update as described
in my original post is in a field that contains other text and code
that I want to keep. Each of the 10K+ fields contains the description
of a particular audio book so each total field is different except
that each one contains the phrase I want to update. Here is an example
of a record's field containing the phrase (near the first part) I want
to update:

<table><tr><td><img src="http://www.audiobooksonline.com/media/compact-
disc-50X50.gif" width="50" height="50" alt="compact disc audio book"
border="0" /><center><strong><font color="#990000">Free USA Shipping,
Orders $50 or more!</font></strong></center></p><p><font size="2"
face="Arial, Helvetica, sans-serif">List <strike>$37.00</
strike><p>Written by Ann Brashares - Audio book performed by Kimberly
Farr - Unabridged Fiction - <b><font color="#FF0000">COMPACT DISCS</
font></b></p><p>Publisher, Listening Library (January 2008)</
p><p>NOTE: <b>RETAIL EDITIONS</b> are packaged in attractive, compact
cardboard, jewel-case or DVD shrink-wrapped cases, with full-color
art.</p><p><A HREF="http://www.audiobooksonline.com/audio/3-Willows-
Sisterhood-Grows-Ann-Brashares-unabridged-Kimberly-Farr-Listening-
Library.mp3">Listen to an MP3 audio clip.</A></p><p><b>Summer is a
time to grow seeds.</b></p><p>Polly has an idea that she can't stop
thinking about, one that involves changing a few things about herself.
She's setting her sights on a more glamorous life, but it's going to
take all of her focus. At least that way she won't have to watch her
friends moving so far ahead.</p><p><b>Roots</b></p><p>Jo is spending
the summer at her family's beach house, working as a busgirl and
bonding with the older, cooler girls she'll see at high school come
September. She didn't count on a brief fling with a cute boy changing
her entire summer. Or feeling embarrassed by her middle school
friends. And she didn't count on her family at all. . .</
p><p><b>Leaves</b></p><p>Ama is not an outdoorsy girl. She wanted to
be at an academic camp, doing research in an air-conditioned library,
earning A's. Instead her summer scholarship lands her on a wilderness
trip full of flirting teenagers, blisters, impossible hiking trails,
and a sad lack of hair products.</p><p>It is a new summer. And a new
sisterhood. Come grow with them.</p><p><b>About the Author:</b> “I
don’t really write with the idea of trying to teach any lessons. I
want to tell a story as truthfully and engagingly as I can, and then
let the chips fall where they may.” —Ann Brashares</p><p>Ann Brashares
grew up in Chevy Chase, Maryland, with three brothers and attended a
Quaker school in the D.C. area called Sidwell Friends. She studied
Philosophy at Barnard College, part of Columbia University in New York
City. Expecting to continue studying philosophy in graduate school,
Ann took a year off after college to work as an editor, hoping to save
money for school. Loving her job, she never went to graduate school,
and instead, remained in New York City and worked as an editor for
many years. Ann made the transition from editor to full-time writer to
write her first novel, The Sisterhood of the Traveling Pants.</p></
font></td></tr></table>

What would the update query look like?

Is there a resource on the Web that would instruct me how to create
the query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top