Subject: Re: [xsl] complicated sort problem From: "Dimitre Novatchev" <dnovatchev@xxxxxxxxx> Date: Wed, 16 May 2007 06:08:27 -0700 |
fileX.xml:
<document> <date>20071805101800</date>(yyyymmddhhmmss) <url>folderX/foldery/</url> <other tags that aren't to interest> </document>
I know the shorter solution would be to have a date attribute to the <list> xml file like <file date="2007...">file1.xml</file>
But it's a little more complicated than that, I can't really put the data as an attribute so I need to do it with the xml-s structured like that.
Try something like this (BTW your example is not correct -- there is no 18th month):
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/*"> <xsl:copy> <xsl:for-each select="file"> <xsl:sort select="substring(document(.)/*/date,1,4)" data-type="number"/> <xsl:sort select="substring(document(.)/*/date,5,2)" data-type="number"/> <xsl:sort select="substring(document(.)/*/date,7)" data-type="number"/> <xsl:copy-of select="."/> </xsl:for-each> </xsl:copy> </xsl:template> </xsl:stylesheet>
-- Cheers, Dimitre Novatchev --------------------------------------- Truly great madness cannot be achieved without significant intelligence. --------------------------------------- To invent, you need a good imagination and a pile of junk ------------------------------------- You've achieved success in your field when you don't know whether what you're doing is work or play
10x. Cheers
----- Original Message ---- From: Dimitre Novatchev <dnovatchev@xxxxxxxxx> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Sent: Wednesday, May 16, 2007 2:42:58 PM Subject: Re: [xsl] complicated sort problem
On 5/16/07, Vaduvoiu Tiberiu <vaduvoiutibi@xxxxxxxxx> wrote: > Similar problem with the one I had yesterday: > I need to sort the following xml: > > <list> > <file>file1.xml</file> > <file>file2.xml</file> > ...... > <file>file100.xml</file> > </list> > > each of these files have some tags (2 of which are:) > <date>20071805101800</date>(yyyymmddhhmmss) > <url>folderX/foldery/</url> > > So I need to sort the first xml by the date (which is in each fileX.xml). Is that possible? .
The short answer is: Yes.
A more specific solution with code could be produced, once the structure of the
file<N>.xml
files is known.
-- Cheers, Dimitre Novatchev --------------------------------------- Truly great madness cannot be achieved without significant intelligence. --------------------------------------- To invent, you need a good imagination and a pile of junk ------------------------------------- You've achieved success in your field when you don't know whether what you're doing is work or play
____________________________________________________________________________________Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] complicated sort problem, Vaduvoiu Tiberiu | Thread | [xsl] EXE verson of Saxon, J. S. Rawat |
Re: [xsl] complicated sort problem, Vaduvoiu Tiberiu | Date | Re: [xsl] Formatting string, Abel Braaksma |
Month |