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
