[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] Transforming XML to CSV

---

---

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>&#xA;</xsl:text>
<xsl:template>

Cheers,

Jarno

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

---