[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] CSV file from an XML source file using XSLT


Subject: RE: [xsl] CSV file from an XML source file using XSLT
From: "G. Ken Holman" <gkholman@xxxxxxxxxxxxxxxxxxxx>
Date: Wed, 20 Aug 2003 16:30:44 -0300

At 2003-08-20 13:41 +0100, Matt Trimmer wrote:
The XML source comes from MS Access. It would seem that Access uses a 2019
(a right single quotation) and not an real apostrophe (0027). So although I
do have control over the input, I can't seem to change it.

Therefore, you don't have control over the input.


It's strange I transformed this data into various XML formats (encoded to
ISO) but they do not give me a problem. However I did use the cdata elements
command which I guess avoided the issue?

No ... CDATA is only syntactic sugar ... if you received no errors then obviously you were not including any characters outside of the ISO character set. Note that using a numeric character reference *is* allowed in an XML document for a character not in the document's character set, because there are no invalid characters in the formation of the character reference.


I am trying to understand your translate function.

http://www.w3.org/TR/1999/REC-xpath-19991116#function-translate


My XSL is quite simple (sample below)

Everywhere where you have


<xsl:value-of select="x"/>

... use ...

<xsl:value-of select="translate(x,'&#8217;',&#34;'&#34;)"/>

This is what I illustrated in my example to you.

, the only challenge is that the Description field

Why not do it for *every* field to protect your stylesheet from future failures related to this character?


I hope this helps.

............... Ken


-- Instructor-led on-site corporate, government & user group training for XSLT and XSL-FO world-wide; please contact us for the details; Next public European delivery: 3-day XSLT/2-day XSL-FO 2003-09-22

G. Ken Holman                 mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
Box 266, Kars, Ontario CANADA K0A-2E0    +1(613)489-0999 (F:-0995)
ISBN 0-13-065196-6                       Definitive XSLT and XPath
ISBN 0-13-140374-5                               Definitive XSL-FO
ISBN 1-894049-08-X   Practical Transformation Using XSLT and XPath
ISBN 1-894049-11-X               Practical Formatting Using XSL-FO
Member of the XML Guild of Practitioners:     http://XMLGuild.info
Male Breast Cancer Awareness  http://www.CraneSoftwrights.com/s/bc


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




Current Thread
Keywords