RE: Sorting by days of the week

Play the video

Subject: RE: Sorting by days of the week
From: "Ragulf Pickaxe" <jawxml@xxxxxxxxxxx>
Date: Tue, 23 Dec 2003 08:33:05 +0000

Hello, I am a newbee myself, but perhaps something like this?

If you have a variable called DaysOfWeek containing the following nodeset:
<Week>
 <Day>MON</Day>
 <Day>TUE</Day>
 <Day>WEN</Day>
 <Day>THU</Day>
 <Day>FRI</Day>
<!-- perhaps also one for SAT and SUN -->
</Week>

If it is possible to sort like the following....?

<xsl:sort select="pos($DaysOfWeek/Day[.=substring(dayCode,3)]" type="number"/> <xsl:sort select="substring(daycode,4,1)" type="number"/>

I am not very good at xpath, so the syntax in the predicative is probably wrond, and I do not know if this kind of sort is even possible - what is meant is that the sort - instead of sorting over dayCode - should sort over the dayCode's position in the variable (the position of the Day element that have the same value as the dayCode).

So this is as much a question from me as a try for a solution.

Regards, and merry christmas,
Ragulf Pickaxe :)

From: allan.mccluskey@xxxxxxxxxxxxxxxxx
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Sorting by days of the week
Date: Tue, 23 Dec 2003 13:49:24 +1100

G'day all,

I need to sort my output by days of the week. i.e. I have a element called
'dayCode' which can contain one of the following values: MON1, MON2, TUE1,
TUE2, WED1, WED2, THU1, THU2, FRI1, FRI2 etc etc

I've tried using <xsl:sort select="dayCode" order="ascending"/> but as you
would expect, the output order is FRI, MON, THU, TUE, WED.

Is there a way to do this kind or sort??

Cheers
Allan

_________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

Current Thread
Re: Sorting by days of the week, (continued) Vasu Chakkera - Sat, 27 Dec 2003 12:20:21 -0500 (EST) Vasu Chakkera - Sat, 27 Dec 2003 12:20:30 -0500 (EST) Vasu Chakkera - Sat, 27 Dec 2003 12:20:45 -0500 (EST) Vasu Chakkera - Sat, 27 Dec 2003 12:29:42 -0500 (EST) Ragulf Pickaxe - Tue, 23 Dec 2003 03:33:41 -0500 (EST) <= Jarno . Elovirta - Tue, 23 Dec 2003 03:44:49 -0500 (EST)

<- Previous	Index	Next ->
Re: Sorting by days of the we, Vasu Chakkera	Thread	RE: Sorting by days of the we, Jarno . Elovirta
Sorting by days of the week, allan . mccluskey	Date	RE: Sorting by days of the we, Jarno . Elovirta
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >