I have a requirement to split a number using XSL into two parts. The integer part and decimal part.

If my initial XML element was <NUMBER>12.99</NUMBER>
I need my new elements to be:

<NUMBERINT>12</NUMBERINT>
<NUMBERDEC>99</NUMBERDEC>

I tried using the following XSL but thought there must be a better way.

<NUMBERINT>
    <xsl:for-each select="//NUMBER">
         <xsl:choose>
             <xsl:value-of select="substring(format-number(//NUMBER*100, '#.##'), 1, string-length(format-number(//NUMBER*100, '#.##'))-3)" />
         </xsl:choose>
    </xsl:for-each>
</NUMBERINT>
<NUMBERDEC>
   <xsl:for-each select="//NUMBER">
        <xsl:choose>
            <xsl:value-of select="substring(format-number(//NUMBER*100, '#.##'), string-length(format-number(//NUMBER*100, '#.##'))-1, string-length(format-number(//NUMBER*100, '#.##'))-3)" />
        </xsl:choose>
   </xsl:for-each>
</NUMBERDEC>

If anyone has any ideas i'd really appreciate your knowledge.

Cheers,
Francis

Firstly, your use of "//" is quite wrong. //NUMBER selects all the numbers in the document. You don't want to process all the numbers while generating one <NUMBERINT> result element, let alone doing it again in an inner loop.

Also, your use of xsl:choose is wrong. The only things allowed inside xsl:choose are xsl:when and xsl:otherwise.

There are two ways you can break the number up: using string manipulation or using arithmetic. For example:

<xsl:template match="NUMBER">
<NUMBERINT>
  <xsl:value-of select="substring-before(., '.')"/>
</NUMBERINT>
<NUMBERDEC>
  <xsl:value-of select="substring-after(., '.')"/>
</NUMBERDEC>
</xsl:template>

or if you prefer:

<xsl:template match="NUMBER">
<NUMBERINT>
  <xsl:value-of select="floor(.)"/>
</NUMBERINT>
<NUMBERDEC>
  <xsl:value-of select=". mod 1"/>
</NUMBERDEC>
</xsl:template>

These two solutions might not do quite the same thing if the numbers are negative.

Michael Kay


Michael Kay
http://saxon.sf.net/

Thank you Mike.

That is much neater.