Faith SET VAR v1 = (SSTRIP(.VCUSTSRCH,''''))
The four single quotes. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Faith Sent: Tuesday, August 25, 2009 12:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SSTRIP to strip out an apostrophe from a string How do you strip a single quote out of a string using SSTRIP? I am trying to strip apostrophes (single quotes) out of a string and cannot get a syntax for the SSTRIP to work. SET VAR vCustSrch = (SSTRIP(.vCustSrch, ''') THe above treates the two leading quotes as the quote pair and the third quote as the first of two quotes. I have tried variations with these manipulations SET VAR vQuote TEXT = ((CVAL('QUOTE')) SET VAR vApos TEXT = .vQuote +.vQuote + .vQuote SET VAR vCustSrch = (SSTRIP(.vCustSrch, .vApos) set var vSS TEXT = (CHAR(39))+(CHAR(39))+(CHAR(39)) SET VAR vCustSrch = (SSTRIP(.vCustSrch, .vSS) SET QUOTES = ? SET VAR vCustSrch = (SSTRIP(.vCustSrch, ?'?) SET QUOTES = '
