tags:

views:

368

answers:

1
Q: 

xsl truncate a decimal

Hi

I have an xml file with an xsl that I am trying to change the way the numbers are displayed. In the xml all the numbers are in the format 00:12:34

I need to remove the first 2 zeros and the colon and just display 12:34

I am not sure if I use a substring or a decimal format. I am pretty new to this so any help would be marvellous.

code in the xsl is as below:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;

<xsl:template match="/">
  <html>
    <body>
     <table class="albumTable" cellpadding="0" cellspacing="0" border="0" width="100%">    
      <xsl:for-each select="track">
         <tr>
       <td><xsl:value-of select="duration"/></td>
      </tr>
            </xsl:for-each>
     </table>
  </body>
  </html>
</xsl:template>
</xsl:stylesheet>
+4  A: 

This is simple:

<xsl:value-of select="substring-after(duration, ':')" />

See: substring-after() in the W3C XPath 1.0 spec.

This is a little more defensive (for the case that the "hours" part is unexpectedly not '00:'):

<xsl:choose>
  <xsl:when test="substring(duration, 1, 3) = '00:')">
    <xsl:value-of select="substring-after(duration, ':')" />
  </xsl:when>
  <xsl:otherwise>
    <xsl:value-of select="duration" />
  </xsl:otherwise>
</xsl:choose>
Tomalak  2009-07-30 09:23:28
+1 extra for defensive programming
Scoregraphic  2009-07-30 09:44:07
Thank you, that was perfect
 2009-07-30 10:26:13

related questions

xslt and xpath: match conditionally upon current node value
How can I make an exact copy of a xml node's children with XSLT?
How to escape XML content with XSL to safely output it as JSON?
How do I convert a .docx to html using asp.net?
Using XSLT, How Do You Insert XML Into an existing XML node
How can I lay images out in a grid using XSL-FO?
How to validate an XML file against a schema using Visual Studio 2005
What is a good resource for learning XSL?
xslt: apply-templates in reverse order
How do you add an image in XSLT?
If you were programming a calendar in HTML would you use Table tags or Div tags?
How to Convert a StreamReader into an XMLReader object in .Net 2.0/C#
Can I create a value for a missing tag in XPath?
ASP.NET MVC vs. XSL
How to apply an XSLT Stylesheet in C#
XSLT dividing a list of nodes in half
XSLT nodesets Length
using a html entity in xslt (e.g. &nbsp;)
XSLT Find and Replace with Unique
XSL Dynamic Element Names
XSLT - Reverse Find in a string
VS2008 SP1 crashes when debugging an XSLT file
Is it "bad practice" to be sensitive to linebreaks in XML documents?
How do you use a variable in xsl when trying to select a node?
.Net XML comment into API Documentation