RE: quote in string

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 27 Sep 2000 16:28:32 -0400
Message-Id: <10632.118068@fatcity.com>

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_01C028C1.810F8110
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks for your suggestions.=20
However the root of the problem is the replace(). I can get around it = with
what you have suggested though by substr() and concatenating it back together. =20

Thanks again
Lisa

-----Original Message-----
From: elkinsl_at_flash.net [mailto:elkinsl_at_flash.net] Sent: Wednesday, September 27, 2000 4:32 PM To: Multiple recipients of list ORACLE-L Subject: Re: quote in string

Lisa,

Try coding the INSTR as:

instr(name,'''') > 0

The first quote denotes the start of the string, the second and third = quotes

gives one quote, and the fourth closes the string. Try the following 2 queries=20
to get a feel for it:

select 'O''Connor' From Dual; 2 quotes outputting one quote select '''' from dual; Now outputting just a single quote

If seeing so many tickies starts to get confusing, you can use the CHR function=20
directly in the INSTR:

instr(name,chr(39)) > 0

Or some people like to assign CHR(39) (or '''') to a variable and refer = to
the=20
variable throughout their code. Those are just a few of the *many* ways = to=20
handle this. You may prefer other suggestions that are sure to appear.

Regards,

L. Elkins

On Wed Sep 27 14:36:39 2000, "Koivu, Lisa" <lkoivu_at_qode.com>,ORACLEL @fatcity.com wrote:

> Hi all -=20

>=20
> I'm putting my developer hat on again. I am writing a procedure
that=20
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.=20

>=20

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

>=20

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

>=20


> V: 954.484.3191, x174

> F: 954.484.2933=20

> C: 954.658.5849
> http://www.qode.com

>=20
> "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."

>=20
>=20

>=20

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

>=20

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

>=20


> V: 954.484.3191, x174

> F: 954.484.2933=20

>=20


> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

> <HTML>

> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html;
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version
> 5.5.2650.12">
> <TITLE>quote in string</TITLE>
> </HEAD>
> <BODY>

>=20

> Hi all - 
> 

>=20

> I'm putting my developer hat on
> again.=A0 I am writing a procedure that parses through a string.=A0 =
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=20
trip onto it in
> my code (and get it out of my string) is to fall into an exception =
and
check=20
character by
> character and recreate the string in a variable, and handle the =
exception=20
caused by the
> single quote when it occurs, ignoring the current character, and
continuing.
> 

>=20


> <P><FONT SIZE=3D2 FACE=3D"Arial">Has anyone got a better idea?=A0

> 
> Thanks in advance for any
> suggestions. 
> 

>=20

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

>=20


> <P><FONT SIZE=3D1 FACE=3D"Arial">V: 954.484.3191, x174</FONT>

> <BR><FONT SIZE=3D1 FACE=3D"Arial">F: 954.484.2933 </FONT>

> C: 954.658.5849
> <A
> HREF=3D"http://www.qode.com"
> TARGET=3D"_blank">http://www.qode.com</A>
> 

>=20

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

>=20

> </BODY>
> </HTML>

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author:=20
INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C028C1.810F8110
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: quote in string</TITLE>
</HEAD>
<BODY>

Thanks for your suggestions. However the root of the problem is the replace(). I = can get around it with what you have suggested though by substr() and = concatenating it back together.

<P><FONT SIZE=3D2>Thanks again</FONT>
<BR><FONT SIZE=3D2>Lisa</FONT>
</P>
<BR>

-----Original Message----- From: elkinsl_at_flash.net [<A = HREF=3D"mailto:elkinsl_at_flash.net">mailto:elkinsl_at_flash.net</A>]

<BR><FONT SIZE=3D2>Sent: Wednesday, September 27, 2000 4:32 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: quote in string</FONT>
</P>
<BR>

Lisa,

Try coding the INSTR as:

instr(name,'''') > 0

The first quote denotes the start of the string, the = second and third quotes 
 gives one quote, and the fourth closes the string. = Try the following 2 queries 
 to get a feel for it:

select 'O''Connor' From Dual; 2 quotes outputting one = quote
 select '''' from =
dual;        Now outputting just a = single quote

If seeing so many tickies starts to get confusing, = you can use the CHR function 
 directly in the INSTR:

instr(name,chr(39)) > 0

Or some people like to assign CHR(39) (or '''') to a = variable and refer to the 
 variable throughout their code. Those are just a few = of the *many* ways to 
 handle this. You may prefer other suggestions that = are sure to appear.

Regards,

L. Elkins

On Wed Sep 27 14:36:39 2000, "Koivu, Lisa" = <lkoivu_at_qode.com>,ORACLE-
 L_at_fatcity.com wrote:

<P><FONT SIZE=3D2>&gt; Hi all - </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; 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,

<BR><FONT SIZE=3D2>&gt; and continuing. </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Has anyone got a better idea?&nbsp; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks in advance for any suggestions. </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>&gt; Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>&gt; Qode.com</FONT>
<BR><FONT SIZE=3D2>&gt; 4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>&gt; Suite G104</FONT>
<BR><FONT SIZE=3D2>&gt; Fort Lauderdale, FL&nbsp; 33319</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>&gt; F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>&gt; C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://www.qode.com" =

TARGET=3D"_blank">http://www.qode.com</A> > 
 > "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."

<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Hi all - </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I'm putting my developer hat on =

<BR><FONT SIZE=3D2>&gt; and continuing. </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Has anyone got a better idea?&nbsp; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks in advance for any suggestions. </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>&gt; Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>&gt; Qode.com</FONT>
<BR><FONT SIZE=3D2>&gt; 4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>&gt; Suite G104</FONT>
<BR><FONT SIZE=3D2>&gt; Fort Lauderdale, FL&nbsp; 33319</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>&gt; F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>&gt; C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://www.qode.com" =

<BR><FONT SIZE=3D2>&gt; &lt;HTML&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;HEAD&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;META HTTP-EQUIV=3D&quot;Content-Type&quot; =

CONTENT=3D"text/html;
 > charset=3Diso-8859-1"> > <META NAME=3D"Generator" = CONTENT=3D"MS Exchange Server version > 5.5.2650.12"> > <TITLE>quote in = string</TITLE>

<BR><FONT SIZE=3D2>&gt; &lt;/HEAD&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BODY&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;FONT SIZE=3D2 =

FACE=3D"Arial">Hi all -

<BR><FONT SIZE=3D2>&gt; &lt;/P&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;FONT SIZE=3D2 =

FACE=3D"Arial">I'm putting my developer hat on > again.=A0 I am writing a procedure that parses = through a string.=A0 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.

<BR><FONT SIZE=3D2>&gt; &lt;/FONT&gt;&lt;/P&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;FONT SIZE=3D2 =
FACE=3D&quot;Arial&quot;&gt;Has anyone got a better idea?=A0</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;/FONT&gt;</FONT>

> Thanks in advance for any

<BR><FONT SIZE=3D2>&gt; suggestions. &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;/P&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;B&gt;&lt;FONT SIZE=3D1 =

FACE=3D"Arial">Lisa Rutland > Koivu > Oracle Database > Administrator

<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;Qode.com&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;4850 North State Road 7&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;Suite G104&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;Fort Lauderdale, FL=A0</FONT>
<BR><FONT SIZE=3D2>&gt; 33319&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;/P&gt;</FONT>

>

<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;V: 954.484.3191, x174&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;F: 954.484.2933 &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;C: 954.658.5849&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;BR&gt;&lt;FONT SIZE=3D1 =
FACE=3D&quot;Arial&quot;&gt;&lt;A</FONT>

> HREF=3D"<A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>" > TARGET=3D"_blank"><A = HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></A>

<BR><FONT SIZE=3D2>&gt; &lt;/P&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;P&gt;&lt;I&gt;&lt;FONT =

COLOR=3D"#000000" SIZE=3D1 > FACE=3D"Arial">"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."

<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &lt;/BODY&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &lt;/HTML&gt;</FONT>
</P>

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: elkinsl_at_flash.net</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 To REMOVE yourself from this mailing list, send an = Received on Wed Sep 27 2000 - 15:28:32 CDT