Just to add to what you said, the explanation for the second quote within the quoted string, is the first character "escapes" the second one, identifying it as literal.
It's like when you want an actual Ampersand in a string and you get an underscore. You simply double the ampersand within the quoted string and you get the literal ampersand... ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 28, 2011 4:36 PM Subject: [RBASE-L] - Re: SRPL ' Marc, It takes a bit of mental gymnastics, but perhaps this will help. Virtually all modern programming languages handle quote embedded in a string the same way. Set var vString = '' Will store a zero length string (always NULL in R:BASE) Set var vString = ''' Will throw and error because quotes must always be balanced. Otherwise, the interpreter gets lost and doesn't know where the string starts and ends. Set var vString = '''' Will store one quote. The outside quotes delimit the string, and the 2 quotes inside get evaluated to 1 quote. Set var vString = 'I''m a programmer' I'm a programmer Is what gets stored in memory. Hope this helps. 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 MDRD Sent: Tuesday, June 28, 2011 3:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SRPL ' Thanks everyone I seem to have a hard time understanding the double quote thing. Marc -------------------------------------------------- From: "A. Razzak Memon" <[email protected]> Sent: Tuesday, June 28, 2011 2:27 PM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Re: SRPL ' > At 03:16 PM 6/28/2011, Marc Schluter wrote: > >>I am trying to strip out any apostrophes ' from the last >>name field but can't seem to get this to work. >>UPDATE ptinfo SET L_name = (SRPL(L_name, ''''', '''', 0)) >> >>I think the number of single quotes is messing me up. >> >>Thanks for any suggestions >>Marc >> > > > Marc, > > You will need to double up the quote mark. > > Here's how: > > UPDATE PtInfo SET L_Name = (SRPL(L_Name, '''', '''''', 0)) > RETURN > > That's all there is to it! > > Very Best R:egards, > > Razzak. > >
