On Sun, 8 Nov 2009 14:15:01 -0800, lbohen <lbo...@discussions.microsoft.com> wrote:
>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?
The quotemarks are probably at fault. I'm assuming that this string is embedded in a larger field; if so I'd suggest an Update query
UPDATE mytable SET thisfield = Replace([thisfield], "border=""0"" /><center><strong><font color=""#990000"">Free USA Shipping, Orders $50 or more!</font></strong></center></p><p>", "Border=""0"" />") WHERE thisfield LIKE "*border=""0"" /><center><strong><font color=""#990000"">Free USA Shipping, Orders $50 or more!</font></strong></center></p><p>", "Border=""0"" />";
Edit out the line breaks introduced by the newsreader.
Note that to express a " character in a string delimited by " characters, you double it up: "" becomes ". --
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. -- Frank H Rockford, IL
> 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. > -- > Frank H > Rockford, IL
> "lbohen" wrote: > > I have a database of over 10K records, each has the followingphrasethat 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 thephraseas > > the search does NOT find it and I know it is in each record.
> > How do I find & replace thephrase?
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?
|
