Thanks Dennis
I don't drink beer but think I should start since my head is spinning.
Stay Frosty my friend
Marc
--------------------------------------------------
From: "Dennis McGrath" <[email protected]>
Sent: Tuesday, June 28, 2011 3:36 PM
To: "RBASE-L Mailing List" <[email protected]>
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.
