xsl-list
[Top] [All Lists]

Re: CSV file from an XML source file using XSLT

2003-08-16 09:41:55
At 2003-08-16 00:11 +0100, Matt Trimmer wrote:
I am building a CSV file from an XML source file using XSLT. The end file
needs to contain a british pound sign. In the XML source file the £ sing is
encased in a CDATA section. I need to make the CSV file ISO as opposed UTF
otherwise common viewers such as excel will not read the information in the
CSV file properly.

If I parse the file with ISO selected as the output my parser wont let it.
If I use UTF, it's fine but then no one can view the file properly with
"standard" tools.

Any ideas?

Some tools support <xsl:output method="text" encoding="iso-8859-1"/> to use Latin 1 as the serialization for a text file.

That should give you what you need, but a processor is not obliged to support it.

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(_at_)CraneSoftwrights(_dot_)com
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