FAQ,
I wish to transform XML which looks like this:
<row>
<column>Value 1</column>
<column>Value 2</column>
<column>Value 3</column>
</row>
<row>
<column>Value 4</column>
<column>Value 5</column>
<column>Value 6</column>
</row>
Into a comma separated values (CSV) format looking like this:
"Value 1","Value 2", "Value 3"
"Value 4","Value 5", "Value 6"
so it can be read in a spreadsheet program. What XSL will do
this? I'm
having trouble because the result is not a hierarchical result.
<xsl:template match="row">
<xsl:for-each select="column">
<xsl:if text="not(position() = 1)">,</xsl:if>
<xsl:value-of select="." />
</xsl:for-each>
<xsl:text>
</xsl:text>
<xsl:template>
Cheers,
Jarno
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list