Karen, The where clause was to prevent accidentally updating records that were already updated. Knowing myself, and assuming others make the same mistakes, I write defensively. It helps me avoid OMG events!!!!
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Thursday, November 14, 2013 8:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: String replace I set up a test table with text that had: Hello" there Hello"there and then tried Denni's Update command without the Where clause. It updated fine, with the results: Hello"" there (changed) Hello"there (not changed) It worked without the where clause so you could try leaving that off, Bob, unless you have a really large table and need a where clause for speed. Karen -----Original Message----- From: Dennis McGrath <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Wed, Nov 13, 2013 5:19 pm Subject: [RBASE-L] - RE: String replace Copy my code exactly. There is a space in there after the double quote. quote-percent-dblquote-space-percent-quote Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]> -----Original Message----- From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Bob Thompson Sent: Wednesday, November 13, 2013 5:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: String replace Thanks, however the %"% pulls up all instances of the double quote in my case. The % is the many character. So '%"%' would mean retrieve all records that include a double quotes. I need only the records containing a double quote with a space immediately behind it Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 13, 2013, at 4:49 PM, Dennis McGrath <[email protected]<mailto:[email protected]>> wrote: > I'm assuming the quote you are searching for is the double quote and that your rbase quote setting is the single quote > > This works for me as far as finding the double-quote followed by a space. > > browse all from testreplace where testreplace like '%" %' > > This does the update. In addition, it will not mess up if run again. > > update testreplace + > set testreplace = (SRPL(testreplace,'" ','"" ',0)) + > where testreplace not like '%"" %' > > > Dennis McGrath > Software Developer > QMI Security Solutions > 1661 Glenlake Ave > Itasca IL 60143 > 630-980-8461 > [email protected]<mailto:[email protected]> > -----Original Message----- > From: [email protected]<mailto:[email protected]> > [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Bob > Thompson > Sent: Wednesday, November 13, 2013 4:30 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - String replace > > It is the simple things that sometimes stump me. > > I need to replace the following characters in text fields over many records. > > Example. > > 2-5/8" Long Dimension > > Needs to be > > 2-5/8"" Long Dimension > > I need to replace all ("space) with > (""space) > > So far everything I have tried, ignores the space following the double quote. > > I have not even been successful in searching records to find which ones contain the double quote followed by a space. > > I have used (char(32)) in several configurations but with no luck. > > Any thoughts appreciated. > > Bob Thompson > LaPorte, IN > 219-363-7441 > >
