You don't need the FO stuff, though. (I grabbed one of my existing files to
modify it for your problem and forgot to trim out that namespace.)
Replace
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:fo="http://www.w3.org/1999/XSL/Format"; exclude-result-prefixes="fo">
with
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
Sorry about that.
Jay Bryant
Bryant Communication Services
----- Original Message -----
From: "Jay Bryant" <jay(_at_)bryantcs(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Monday, January 16, 2006 9:45 AM
Subject: Re: [xsl] Problem in grouping and filering.
You have a very common duplicate problem, the solution to which is in the
FAQ here:
http://www.dpawson.co.uk/xsl/sect2/N2696.html
In your case, you need something like this:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:fo="http://www.w3.org/1999/XSL/Format"; exclude-result-prefixes="fo">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="hotels">
<unique-longtext1s>
<xsl:for-each select="rate-codes/ref[not(longtext1 =
following::longtext1)]">
<xsl:copy-of select="longtext1"/>
</xsl:for-each>
</unique-longtext1s>
</xsl:template>
</xsl:stylesheet>
Tested with Saxon.
Jay Bryant
Bryant Communication Services
----- Original Message -----
From: "Bamanie Kumarasena" <bkumarasena(_at_)openworld(_dot_)org>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Monday, January 16, 2006 12:43 AM
Subject: [xsl] Problem in grouping and filering.
Hi,
I am having the following XML ( similar one). I need to filter out the
minimum unique 3 rates. But I have no way of keeping a count in XSL
, so I count by the preceding:: node. This counts with the duplicate
value. Is there a way to do this ?
The XML I have :
rates.xml
---------
<hotels>
<rate-codes>
<rateperday>100</rateperday>
<ref>
<id>3</id>
<longtext1>Daily Leisue Rate</longtext1>
<longtext2></longtext2>
</ref>
</rate-codes>
<rate-codes>
<rateperday>103</rateperday>
<ref>
<id>7</id>
<longtext1>Discounted Leisure Rate</longtext1>
<longtext2></longtext2>
</ref>
</rate-codes>
<rate-codes>
<rateperday>107</rateperday>
<ref>
<id>8</id>
<longtext1>Discounted Leisure Rate</longtext1>
<longtext2></longtext2>
</ref>
</rate-codes>
<rate-codes>
<rateperday>120</rateperday>
<ref>
<id>96</id>
<longtext1>Celebration Package - Lowry Hotel</longtext1>
<longtext2></longtext2>
</ref>
</rate-codes>
........
</hotels>
I need to get all the unique rate details sorted according to rateperday
and filtered the first 3 rates.
rates.xsl
-----------
<xsl:template match="hotels">
<xsl:variable name = "uniquelist"
select =
"rate-codes[not(ref/longtext1=following::rate-codes/ref/longtext1)]"/>
<xsl:for-each select="$uniquelist">
<xsl:sort select="rateperday" data-type="number"
order="ascending"/>
<xsl:variable name="count"><xsl:value-of
select="(count(preceding::rate-codes))"/></xsl:variable>
<xsl:if test="$count < 3">
<xsl:value-of select="."/>
</xsl:if>
</xsl:for-each>
</xsl:template>
This is the xsl which I have, here I use the count:: preceding , but it
counts the duplicates also. Please send me a quick response as this is
quite urgent.
The output I want is
Daily Leisue Rate
Discounted Leisure Rate
Celebration Package - Lowry Hotel
But the output I get is:
Daily Leisue Rate
Discounted Leisure Rate
Thanks,
Bamanie.
--
Bamanie Kumarasena
Software Engineer ( JAVA)
Open World Lanka (Pvt) Ltd, 41 Dutugamunu Street, Pamankada, Dehiwala,
LK
Tel: +94 11 4403904 Ext. 114
Fax: +94 11 2854815
http://www.openworld.org/
CONFIDENTIALITY NOTICE The information contained in this message is
confidential, intended only for the use of the individual or the entity
named as recipient. If the reader of this message is not that recipient,
you are notified that any dissemination, distribution or copy of this
message is strictly prohibited. If you have received this message in
error, please immediately notify us by telephone on the number above.
Your co-operation is appreciated.
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--