Re: amp

Has anyone had this similar problem with MS Word's autoformat function?  We
have a newsletter and the editor uses MS Word to write his article, he then
submits the text to a web form that stores the information in a database
which I later retrieve and put into an XML document for output to PDF and
HTML.  The problem is I am not sure how I could escape those special
characters that MS Word uses, like the special quotes and elipses.  Any help
would be appreciated.

Thanks
Noel

----- Original Message -----
From: "Stevenson Ngila" <Stevenson@xxxxxxxxxxxxxxxxxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Friday, September 27, 2002 6:56 AM
Subject: RE:  amp


> thanks i have used coldfussion which process the XML data and use the
> "Replace(your_db_column_name, "&", "&amp;", "ALL")"
>
> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
> Jarno.Elovirta@xxxxxxxxx
> Sent: 27 September 2002 13:39
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE:  amp
>
>
> Hi,
>
> > The data come from the DB, and it's the user who feed the DB
> > hence can not
> > control user from using '&'. Is there  a way of escaping this
> > character if
> > the data comes from the DB? I have resaerched all over on the
> >  internet but
> > have not gotten an appropriate explaination. It tells me to
> > use '&amp;' but
> > this data comes from the DB, how can i pick all '&' and
> > trasform them in to
> > '&amp;'.
>
> You could preprocess the data with e.g. sed, perl, or with the tool you're
> using to retrieve the documents, just by replacing every '&' character in
> the document with "&amp;". This could, however, not work if the XML
document
> contains entity references (like &nbsp;) or character entity references
> (like &#160;), in which case you should only replace the ampersands that
are
> not entity delimiters.
>
> Cheers,
>
> Jarno
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
>
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list