RE: Unique entries from substrings

Play the video

Subject: RE: Unique entries from substrings
From: "Aron Bock" <aronbock@xxxxxxxxxxx>
Date: Mon, 27 Jun 2005 03:46:16 +0000

Andreas,

You could approach it as a grouping problem, in which case this input:


<REPORT_ACCESS>
  <REPORTS>
    <REPORT>
      <!-- not unique in list -->
      <DATE>07/08/2005</DATE>
    </REPORT>
    <REPORT>
      <!-- unique -->
      <DATE>05/08/2005</DATE>
    </REPORT>
    <REPORT>
      <!-- not unique in list -->
      <DATE>07/08/2005</DATE>
    </REPORT>
    <REPORT>
      <!-- unique 05-2005-->
      <DATE>05/09/2005</DATE>
    </REPORT>
    <REPORT>
      <!-- unique 07-2005-->
      <DATE>07/09/2005</DATE>
    </REPORT>
  </REPORTS>
</REPORT_ACCESS>

with this xsl:

<?xml version="1.0" encoding="iso8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" indent="yes"/> <xsl:strip-space elements="*"/>

<xsl:key match="DATE" name="kDates" use="concat(substring(., 1, 2), substring(., 7))"/>

   <xsl:template match="DATE[generate-id(.) = generate-id(
           key('kDates', concat(substring(., 1, 2), substring(., 7)))[1])
           ]">
       <xsl:value-of select="concat(substring(., 1, 2), substring(., 7))"/>
       <xsl:text>&#xa;</xsl:text>
   </xsl:template>

<xsl:template match="DATE"/>

</xsl:stylesheet>

Yields:

<?xml version="1.0" encoding="UTF-8"?>
072005
052005

Of course, you may have to adjust to include the day, etc ... in which case you wouldn't need the substring and concat business.

--A

_________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Current Thread
Unique entries from substrings Andreas Guther - 27 Jun 2005 02:29:41 -0000 Aron Bock - 27 Jun 2005 03:46:33 -0000 <= <Possible follow-ups> Andreas Guther - 27 Jun 2005 14:53:05 -0000

<- Previous	Index	Next ->
Unique entries from substring, Andreas Guther	Thread	RE: Unique entries from subst, Andreas Guther
select distinct, -= jay =-	Date	Re: select distinct, omprakash . v
	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 >