TopXML Schemas, xsd, xdr library : Sorting by date without using a schema

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

Schemas, xsd, xdr
Schemas, xsd, xdr
Schemas, xsd, xdr Contents
Validating and enforcing a list of attribute values
Entity name support without DTDs
The Loss of Formatting When Adding a Schema
simple xml notepad
Schemas using DBMS_XMLQuery Package
Tips for Designing a DTD - Part 1 of 4
Tips for Designing a DTD- Part 2 of 4 : Semi-Structured Documents
Tips for Designing a DTD- Part 3 of 4 : Database Oriented Data
Tips for Designing a DTD- Part 4 of 4 : Object Oriented Data
Getting the value of an element with optional subelements
XML Code Generator: Generating Wrapper Classes from an XML Schema
What is WDDX?
XSLT Stylesheet for summarizing the structure of an XML document
Validating XML with Schemas
Punctuated Changes In XML Documents
XMLStarlet Command Line XML Toolkit
W2XML v2.0 SR1
Free DTD for Academic Publishers
Arquemie for XML Schemas
XMLStarlet Command Line XML/XSLT Toolkit

<< reBlogger SEO >>

By	Mark Wilson I am the creator of TopXML. I am available for international and local (Australia) contracts. I am a Solution Architect/Business Analyst. I have worked in IT in several countries (NZ, Australia, South Africa, UK) building and training teams for government and very large non-governmental organizations. I am ex-Microsoft Consulting Services. I wrote the first book on Microsoft XML published in 2000 called XML Programming with VB and ASP. Most recently I have been building tools for the SEO industry. Ask me for a 37 point SEO health-checkup for your website.
First Posted	12/03/2007
Times viewed	2551

Sorting by date without using a schema

Summary As there this no support for dates in XSLT, this snippet describes how to format your date using the substring-before() and translate() functions to set you date as a number, which is then sorted on.

XSLT doesn't provide a way to sort by date, so how do we achieve this?

If I store my date as:
2001-01-25T10:05:53 PM

Then all I need to do is find a way to get my date to be a number of the format of yyyymmdd.

This value I then sort this value by the number data type.

In the XSL code you will see that I achieve returning this number by using the substring-before() function to get the value of the date before the 'T'. Then I use the translate() function to remove the dash ('-') in the date.

Additional information
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/headlines"> <html> <body> <h2>Today's Headlines</h2> <xsl:for-each select="article"> <xsl:sort select="translate(substring-before(date,'T'), '-','')" order="descending" data-type="number" /> <font color="blue"> <xsl:value-of select="text()" /> </font> <font color="gray">( <xsl:value-of select="substring-before(date, 'T')" /> )</font> <br /> </xsl:for-each> </body> </html> </xsl:template> </xsl:stylesheet>set nodeCode = xmlCode.createElement("code")

Further additional information
<headlines> <article>Rescued penguins swim home <date>2001-01-25T10:05:53 PM</date> <summary>Some 150 penguins unaffected by the oil spill have begun their long swim from Port Elizabeth back to their breeding habitat at Robben Island.</summary> <category>Science & Nature</category> </article> <article>Bug mops up sewage <date>2001-01-22T08:55:53 PM</date> <summary>A bug found in sewage water has pointed the way to cleaning up a dangerous industrial compound that has become an environmental headache.</summary> <category>Science & Nature</category> </article> <article>In the land of the colour-blind <date>2001-01-26T07:13:44 PM</date> <summary>A hunt to find the cause of widespread colour-blindness among the population of a Western Pacific island has climaxed with the identification of a maverick gene.</summary> <category>Health</category> </article> </headlines>

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :

<< reBlogger SEO >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc A great opportunity to Digital Video Eng here is a greate opportunity as a SMS En A great opportunity as a Network Enginee View all Jobs (Add yours) View all CV (Add yours)

	swimming pool contractor chicago web site design fax online Domain Names online fax D&g sunglasses answering service

	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML