Message-Id: <10632.118040@fatcity.com> From: "Koivu, Lisa" Date: Wed, 27 Sep 2000 14:39:36 -0400 Subject: quote in string This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C028B2.4948485C Content-Type: text/plain; charset="iso-8859-1" Hi all - I'm putting my developer hat on again. I am writing a procedure that parses through a string. However, the single quote ( ' ) is becoming a headache. I can't replace() it, I can't instr() and look for it. I am beginning to think the only way I can get around this when I trip onto it in my code (and get it out of my string) is to fall into an exception and check character by character and recreate the string in a variable, and handle the exception caused by the single quote when it occurs, ignoring the current character, and continuing. Has anyone got a better idea? Thanks in advance for any suggestions. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." ------_=_NextPart_001_01C028B2.4948485C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable quote in string

Hi all -

I'm putting my developer hat on = again.  I am writing a procedure that parses through a = string.  However, the single quote ( ' ) is becoming a headache. I = can't replace() it, I can't instr() and look for it. I am beginning to = think the only way I can get around this when I trip onto it in my code = (and get it out of my string) is to fall into an exception and check = character by character and recreate the string in a variable, and = handle the exception caused by the single quote when it occurs, = ignoring the current character, and continuing.

Has anyone got a better idea?  =
Thanks in advance for any = suggestions.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  = 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The = information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon = Qode.com."