I have a XSLT file I'm using to convert XML output to CSV format. It removes extra whitespace and puts in the commas. It expects something like...

<line>
<column>value</column>
<column>value</column>
<column>value</column>
</line>

In one case I need to do some processing on a value so I have (in XML)...

<line>
<column>value</column>
<column>value</column>
<column><type><val>0</val></type></column>
</line>

The XSL looks like...

<xsl:output encoding="iso-8859-1" method="text" indent="yes" standalone="yes"/>
<xsl:strip-space elements='line' />
<xsl:strip-space elements='column' />


<xsl:template match="line">
  <xsl:apply-templates select="column" />
  <xsl:text>
</xsl:text>
</xsl:template>


<xsl:template match="column">
  <xsl:apply-templates select="type" />

  <xsl:value-of select='normalize-space(translate(., "#xA;#xD;", ""))' />
  <xsl:value-of select='../../@csvSeparator' />
</xsl:template>

<xsl:template match="type">
  <xsl:choose>
  <xsl:when test="val=0">dog</xsl:when>
  <xsl:when test="val=1">cat</xsl:when>
  </xsl:choose>
</xsl:template>

Problem = the xsl:choose works properly so it outputs 'dog', but then it immediately output '0' as well. So I get dog0 or cat1. Any idea what could be causing this? Thanks!

What causes the problem is that immediately after doing

<xsl:apply-templates select="type" />

you then do

<xsl:value-of select='normalize-space(translate(., "#xA;#xD;", ""))' />

so you process the contents of the element twice.

Write two separate template rules, one

<xsl:template match="column[type]"

and one

<xsl:template match="column[not(type)]"

to handle the two different formats for column.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference