Re: re-ordering nodes/partial sort

Play the video

Subject: Re: re-ordering nodes/partial sort
From: "M. David Peterson" <m.david@xxxxxxxxxx>
Date: Sun, 10 Oct 2004 09:38:13 -0700

Hey Kevin,

Does this have to be in document order of the input (or based on an index of some sort) or is this something that can solved simply by using the sort element? Something as simple as this...

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:template match="/">
  <supplements>
  <xsl:apply-templates select="supplements/supp">
   <xsl:sort select="supp-desc"/>
  </xsl:apply-templates>
  </supplements>
</xsl:template>

<xsl:template match="supp">
  <xsl:copy-of select="."/>
</xsl:template>

</xsl:stylesheet>

Will give you this...

<?xml version="1.0" encoding="UTF-8"?>
<supplements>
  <supp>
    <supp-desc>Balcony</supp-desc>
    <supp-price>8.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Bed &amp; Breakfast</supp-desc>
    <supp-price>4.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Bed &amp; Breakfast (child)</supp-desc>
    <supp-price>2.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Full Board</supp-desc>
    <supp-price>60.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Full Board (child)</supp-desc>
    <supp-price>30.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Half Board</supp-desc>
    <supp-price>30.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Half Board (child)</supp-desc>
    <supp-price>15.00</supp-price>
  </supp>
  <supp>
    <supp-desc>Sea View</supp-desc>
    <supp-price>10.00</supp-price>
  </supp>
</supplements>

But it seems that you have a requirement to sort based on doc order as well? Let me know if this is sufficient or if you need further help. The indexed solution is pretty straight forward as well but if this works, no need to further complicate the code if you don't have to.

Best regards,

<M:D/>

Kevin Bird wrote:

Hi

In the following structure I can receive 1 or many <supp> nodes. Some of
the <supp> nodes need re-arranging depending on their <supp-desc>. The
order is: Bed &amp; Breakfast, Bed &amp; Breakfast (child), Half Board,
Half Board (child), Full Board and Full Board (child). Any <supp> with a
<supp-desc> that is not one of the above appear before them in the
output.

Any suggestions would be greatly appreciated.

--INPUT--

<supplements>
	<supp>
		<supp-desc>Sea View</supp-desc>
		<supp-price>10.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Half Board</supp-desc>
		<supp-price>30.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Bed &amp; Breakfast</supp-desc>
		<supp-price>4.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Full Board</supp-desc>
		<supp-price>60.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Half Board (child)</supp-desc>
		<supp-price>15.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Full Board (child)</supp-desc>
		<supp-price>30.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Bed &amp; Breakfast (child)</supp-desc>
		<supp-price>2.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Balcony</supp-desc>
		<supp-price>8.00</supp-price>
	</supp>
</supplements>

--REQUIRED OUTPUT--

<supplements>
	<supp>
		<supp-desc>Sea View</supp-desc>
		<supp-price>10.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Balcony</supp-desc>
		<supp-price>8.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Bed &amp; Breakfast</supp-desc>
		<supp-price>4.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Bed &amp; Breakfast (child)</supp-desc>
		<supp-price>2.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Half Board</supp-desc>
		<supp-price>30.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Half Board (child)</supp-desc>
		<supp-price>15.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Full Board</supp-desc>
		<supp-price>60.00</supp-price>
	</supp>
	<supp>
		<supp-desc>Full Board (child)</supp-desc>
		<supp-price>30.00</supp-price>
	</supp>
</supplements>

Thanks.

--
Kevin

Current Thread
re-ordering nodes/partial sort Kevin Bird - Sun, 10 Oct 2004 16:16:35 +0100 M. David Peterson - Sun, 10 Oct 2004 09:38:13 -0700 <= Kevin Bird - Sun, 10 Oct 2004 19:38:02 +0100 Anton Triest - Sun, 10 Oct 2004 22:05:29 +0200 Kevin Bird - Sun, 10 Oct 2004 22:29:46 +0100 M. David Peterson - Sun, 10 Oct 2004 11:30:37 -0700

<- Previous	Index	Next ->
re-ordering nodes/partial sor, Kevin Bird	Thread	RE: re-ordering nodes/partial, Kevin Bird
re-ordering nodes/partial sor, Kevin Bird	Date	Xslt transform & grouping, Us, row.filter
	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 >