Replacing quotation marks

[J. Muenchbourg]

The following removes any unwanted apostrophes before being inserted
into an sql database:

Articletext = replace(articleText,"'","''")

..but if I need to remove all quotation marks, this doesnt work:

Articletext = replace(articleText,""","''")


????
Muench

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[John Beschler]

"" = empty string
""" = empty string + extra "

To place a " into a string use "".

Your code would then be:
Articletext = replace(articleText,"""","''")
or alternately:
Articletext = replace(articleText,CHR(34),"''")

HTH,
John

>-----Original Message-----
>The following removes any unwanted apostrophes before

being inserted

>into an sql database:
>
>Articletext = replace(articleText,"'","''")
>
>..but if I need to remove all quotation marks, this

doesnt work:

>
>Articletext = replace(articleText,""","''")
>
>
>????
>Muench
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url]

***

>Don't just participate in USENET...get rewarded for it!
>.
>

[Alan]

You need to double-up apostrophes to stop them interfering with the
delimiters needed around textual column contents - why do you need to
double-up quotes?

Alan

"J. Muenchbourg" <jodaddy@canada.com> wrote in message
news:#w4TLrnZDHA.2520@TK2MSFTNGP09.phx.gbl...

> The following removes any unwanted apostrophes before being inserted
> into an sql database:
>
> Articletext = replace(articleText,"'","''")
>
> .but if I need to remove all quotation marks, this doesnt work:
>
> Articletext = replace(articleText,""","''")
>
>
> ????
> Muench
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[action bolt webforumsuser@macromedia.com]

I have been given this string that contains a quotation mark

myString = "the length is 24" long"

how can i replace the " after 24 with the word inches.

i used this to remove any commas from a string

repeat while (thestring contains ",")
thePos = offset(",",theString)
put " "into theString.char[thePos]
end repeat

it doesnt work for a quotation

thanks

[Andrew Morton]

-- Welcome to Director --
s="abc"&quote&"def"
put s
-- "abc"def"
put offset(quote, s)
-- 4
put "inches" into char 4 of s
put s
-- "abcinchesdef"

Andrew

[Gretchen webforumsuser@macromedia.com]

<<I have been given this string that contains a quotation mark

myString = "the length is 24" long"

how can i replace the " after 24 with the word inches.

i used this to remove any commas from a string

repeat while (thestring contains ",")
thePos = offset(",",theString)
put " "into theString.char[thePos]
end repeat

it doesnt work for a quotation

thanks>>

It should work if you sub the key word QUOTE (no quotes around it)

repeat while (thestring contains QUOTE)

Gretchen Macdowall
updateStage, inc.

[Andrew Morton]

--

P.S. "The length is 24" long" is poor English. It should be "the length is 24""
or "it is 24" long".

Andrew