Re: xml to csv

a, dd1
a, dd2

Date: Mon, 21 Nov 2005 10:34:43 GMT
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
From: David Carlisle <davidc@xxxxxxxxx>
Subject: Re:  xml to csv
Message-Id: <200511211034.KAA15109@xxxxxxxxxxxxxxxxx>

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="root">
<xsl:apply-templates select="*[last()]"/>
</xsl:template>

<xsl:template match="root/*">
<xsl:param name="l"/>
<xsl:variable name="here" select="."/>
<xsl:variable name="sep">
<xsl:if test="following-sibling::*">, </xsl:if>
</xsl:variable>
<xsl:for-each select="descendant-or-self::*[not(*)]">
<xsl:choose>
<xsl:when test="$here/preceding-sibling::*">
<xsl:apply-templates select="$here/preceding-sibling::*[1]">
  <xsl:with-param name="l" select="concat(.,$sep,$l)"/>
</xsl:apply-templates>
</xsl:when>
<xsl:otherwise>
  <xsl:value-of select="concat(.,$sep,$l,'

</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

$ saxon bb.xml bb.xsl
a, bb1, ccc1, dd1
a, bb2, ccc1, dd1
a, bb3, ccc1, dd1
a, bb4, ccc1, dd1
a, bb1, ccc2, dd1
a, bb2, ccc2, dd1
a, bb3, ccc2, dd1
a, bb4, ccc2, dd1
a, bb1, ccc1, dd2
a, bb2, ccc1, dd2
a, bb3, ccc1, dd2
a, bb4, ccc1, dd2
a, bb1, ccc2, dd2
a, bb2, ccc2, dd2
a, bb3, ccc2, dd2
a, bb4, ccc2, dd2

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________