Question about pulling distinct using XSL

[Dhiren Joshi]

Hi All ,
I have this XML

<?xml version="1.0" encoding="UTF-8"?>
 
<response>
<info count='235'>
<records>
<field>2004-08-17</field>
<field>3490</field>
</records>
<records>
<field>2004-08-17</field>
<field>...</field>
</records>

<records>
<field>2004-08-17</field>
<field>3490</field>
</records>
<records>
<field>2004-08-17</field>
<field>...</field>
</records>
<records>
..
<field>2004-09-17</field>
<field>3490</field>
</records>
<records>
<field>2004-07-17</field>
<field>...</field>
</records>
<records>
<field>2004-06-17</field>
<field>3430</field>
</records>
<records>
<field>2004-06-17</field>
<field>...</field>
</records>
                ......
</info>
</response>
  

I want to pull the distinct value of just yyyy-mm using XSL/XPath .
The existing code is already in XSL so using XSL is what I got to go ahead and use .
I need some XPath which can help me identify all the distinct yyyy-mm in this document.
Thanks
Dhiren

[Kumar Bisk]

>I need some XPath which can help me identify all the distinct yyyy-mm in this document.

I don't think there would be any straight forward approach for this. You can achieve the same by manipulating each field.

<xsl:for-each select="response/info/records/field">
<xsl:variable name="test" select="."/>
<xsl:variable name="year" select="substring($test,5,1)"/>
<xsl:variable name="month" select="substring($test,8,1)"/>
//check here that value of year and month are "-". If these variables does not contains "-" then it is not is yyyy-mm format.
</xsl:for-each>

hope this would help.

regards,
Ranjan

[Dhiren Joshi]

I need to hold on to each distinct variable of yyyy-mm after the </xsl:for-each>
What would need to be done for that .

<xsl:for-each select="response/info/records/field">
<xsl:variable name="test" select="."/>
<xsl:variable name="year" select="substring($test,5,1)"/>
<xsl:variable name="month" select="substring($test,8,1)"/>
//check here that value of year and month are "-". If these variables does not contains "-" then it is not is yyyy-mm format.
</xsl:for-each>

Thanks
Dhiren