xsl-list
[Top] [All Lists]

Re: amp

2002-09-27 04:27:18
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(_at_)epr(_dot_)footman-walker(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Friday, September 27, 2002 6:56 AM
Subject: RE: [xsl] 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(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com]On Behalf Of
Jarno(_dot_)Elovirta(_at_)nokia(_dot_)com
Sent: 27 September 2002 13:39
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] 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



<Prev in Thread] Current Thread [Next in Thread>