RE: CSV file from an XML source file using XSLT

Play the video

Subject: RE: 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,'’',"'")"/>

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
RE: CSV file from an XML source file using XSLT, (continued) Matt Trimmer - Sun, 17 Aug 2003 13:55:04 -0400 (EDT) G. Ken Holman - Sun, 17 Aug 2003 16:15:14 -0400 (EDT) Matt Trimmer - Sun, 17 Aug 2003 16:45:21 -0400 (EDT) Matt Trimmer - Wed, 20 Aug 2003 08:41:38 -0400 (EDT) G. Ken Holman - Wed, 20 Aug 2003 15:32:32 -0400 (EDT) <=

<- Previous	Index	Next ->
RE: CSV file from an XML sour, Matt Trimmer	Thread	how to use XSLT 1.0 with XSD , ga11
AW: Problem with comparison, Markus Abt	Date	xsl:variable, Zarana Shah
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >