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. > >
