Thanks for the tips. It worked as needed.
Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 14, 2013, at 9:05 AM, Dennis McGrath <[email protected]> wrote: > 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]> > To: RBASE-L Mailing List <[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] > -----Original Message----- > From: [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]> 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] > > -----Original Message----- > > From: [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 > > > > > >
