Faith, I just tried SET VAR vCustSrch = (SSTRIP(.vCustSrch, '''')
That's 4 single quote characters. It worked for me. Is it possible the character you are seeing is not the single quote but the one bleow the tilde on the keyboard? Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Faith Sent: Tuesday, August 25, 2009 11:08 AM 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 = '
