XML to CSV Using XSLT

Question

I have the following XML document:

<projects>   <project>    <name>Shockwave</name>     <language>Ruby</language>     <owner>Brian May</owner>     <state>New</state>     <startDate>31/10/2008 0:00:00</startDate>    </project>   <project>    <name>Other</name>     <language>Erlang</language>     <owner>Takashi Miike</owner>     <state> Canceled </state>     <startDate>07/11/2008 0:00:00</startDate>    </project> ... 

And I'd like to get this from the transformation (XSLT) result:

Shockwave,Ruby,Brian May,New,31/10/2008 0:00:00 Other,Erlang,Takashi Miike,Cancelled,07/11/2008 0:00:00 

Does anyone know the XSLT to achieve this? I'm using .net in case that matters.

Answer 1

Here is a version with configurable parameters that you can set programmatically:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">   <xsl:output method="text" encoding="utf-8" />    <xsl:param name="delim" select="','" />   <xsl:param name="quote" select="'&quot;'" />   <xsl:param name="break" select="'&#xA;'" />    <xsl:template match="/">     <xsl:apply-templates select="projects/project" />   </xsl:template>    <xsl:template match="project">     <xsl:apply-templates />     <xsl:if test="following-sibling::*">       <xsl:value-of select="$break" />     </xsl:if>   </xsl:template>    <xsl:template match="*">     <!-- remove normalize-space() if you want keep white-space at it is -->      <xsl:value-of select="concat($quote, normalize-space(), $quote)" />     <xsl:if test="following-sibling::*">       <xsl:value-of select="$delim" />     </xsl:if>   </xsl:template>    <xsl:template match="text()" /> </xsl:stylesheet>