Ok, thanks for the example. On an smart phone, the spaces are hard to see! Will give it a try
Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Nov 13, 2013, at 5:17 PM, Dennis McGrath <[email protected]> wrote: > 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 >> >> > >
