Subject: Re: [xsl] Selecting the Latest Date From: jeb501@xxxxxxxxxxxxxxx Date: Wed, 8 Feb 2006 10:01:20 +0530 |
Mukul, Thanks for the lighting response, I am already using the below stylesheet to get my required output in html files. I like to pick the value of Date node which is largest of the three, which i like to keep it in the last column of my html sheet. <?xml version="1.0" encoding="ISO-8859-1" ?> - <xsl:stylesheet version="1.0" xmlns:xsl=" http://www.w3.org/1999/XSL/Transform"> - <xsl:template match="/"> - <html> - <body> <h4>Test Report</h4> - <table border="1" cellpadding="4" cellspacing="0"> - <tr bgcolor="#9acd32"> <th>Ref</th> <th>Date</th> <th>Qty</th> <th>S Date</th> </tr> - <xsl:for-each select="data/items"> - <tr> - <td> <xsl:value-of select="ref" /> </td> - <td> <xsl:value-of select="pdate" /> </td> - <td align="right"> <xsl:value-of select="qty" /> </td> <td> the selected value should come here... What xsl syntax i have to use here... </td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet> Thanks again. Regards Eugene Mukul Gandhi <gandhi.mukul@gma il.com> To xsl-list@xxxxxxxxxxxxxxxxxxxxxx 08.02.2006 09:40 cc AM Subject Re: [xsl] Selecting the Latest Date Please respond to xsl-list@xxxxxxxx lberrytech.com You may try something like this <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="text" /> <xsl:template match="/data"> <xsl:for-each select="items/date"> <xsl:sort select="translate(., '.', '')" order="descending" data-type="number" /> <xsl:if test="position() = 1"> <xsl:value-of select="." /> </xsl:if> </xsl:for-each> </xsl:template> </xsl:stylesheet> Regards, Mukul On 2/8/06, jeb501@xxxxxxxxxxxxxxx <jeb501@xxxxxxxxxxxxxxx> wrote: > Hi all, > > From the below XML file how to pick the late date from date node.. > > <?xml version="1.0" encoding="Windows-1252" standalone="yes" ?> > - <data> > - <items> > <ref>28834</ref> > <pdate>01.02.2006</pdate> > <qty>5</qty> > <clno>ax588</clno> > <date>01.02.2006</date> > <clrf>Normal 1</clrf> > <clno>bx588</clno> > <date>03.02.2006</date> > <clrf>Normal 2</clrf> > <clno>bx588</clno> > <date>06.02.2006</date> > <clrf>Normal 3</clrf> > </items> > </data> > > Regards > Eugene
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Selecting the Latest Date, Mukul Gandhi | Thread | Re: [xsl] Selecting the Latest Date, Mukul Gandhi |
Re: [xsl] Selecting the Latest Date, Mukul Gandhi | Date | Re: [xsl] Selecting the Latest Date, Mukul Gandhi |
Month |