[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: "Matt Trimmer" <matt.trimmer@xxxxxxxxxxxxxx> Date: Sun, 17 Aug 2003 21:43:52 +0100 |
Thank you very much! > -----Original Message----- > From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx > [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of > G. Ken Holman > Sent: 17 August 2003 21:13 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: RE: [xsl] CSV file from an XML source file using XSLT > > > At 2003-08-17 18:54 +0100, Matt Trimmer wrote: > >Thanks for this, but this is what I am doing and I get: > > > >Output character not available in this encoding (decimal 8217). > > > >Transformation failed. > > Yes, of course it would ... that character is: > > 2019;RIGHT SINGLE QUOTATION MARK;Pf;0;ON;;;;;N;SINGLE COMMA > QUOTATION MARK;;;; > > ... and that isn't a text character in any character set > other than Unicode. > > At 2003-08-16 00:11 +0100, Matt Trimmer wrote: > >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. > > Then you can't use the right single quotation mark, because > that isn't an > ISO character ... the error message is precise and > unambiguous: you are > asking to output a character that is not available in your > desired encoding. > > Perhaps you could use a single quote in its place. If you don't have > control over your input, you might consider the translate() > function as I > have in the example below, where I first replicate your > problem (you didn't > give us any sample code to work with) and then suggest the > use of the function. > > I hope this helps. > > ............ Ken > > > T:\ftemp>type trimmer.xsl > <?xml version="1.0" encoding="iso-8859-1"?> > <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > xmlns:myns="dummy" > version="1.0"> > > <xsl:output method="text" encoding="iso-8859-1"/> > > <myns:input> Here is a single comma quotation mark: > ’</myns:input> > > <xsl:template match="/"> > <xsl:value-of select="document('')/*/myns:input"/> > </xsl:template> > > </xsl:stylesheet> > > T:\ftemp>saxon trimmer.xsl trimmer.xsl > Error at xsl:value-of on line 11 of file:/T:/ftemp/trimmer.xsl: > Output character not available in this encoding (decimal > 8217) Transformation failed: Run-time errors were reported > > T:\ftemp>type trimmer2.xsl > <?xml version="1.0" encoding="iso-8859-1"?> > <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > xmlns:myns="dummy" > version="1.0"> > > <xsl:output method="text" encoding="iso-8859-1"/> > > <myns:input> Here is a single comma quotation mark: > ’</myns:input> > > <xsl:template match="/"> > <xsl:value-of select="translate(document('')/*/myns:input, > '’',"'")"/> > </xsl:template> > > </xsl:stylesheet> > > T:\ftemp>saxon trimmer2.xsl trimmer2.xsl > Here is a single comma quotation mark: ' > T:\ftemp>rem Done! > > T:\ftemp> > > > -- > 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 > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] CSV file from an XML sour, G. Ken Holman | Thread | RE: [xsl] CSV file from an XML sour, Matt Trimmer |
RE: [xsl] CSV file from an XML sour, G. Ken Holman | Date | Re: [xsl] What is a good way to sty, Peter Flynn |
Month |