Grouping by pattern

bonekrusher · January 19th, 2010, 08:14 AM

Hi,

I have xml table that has about 1000 rows (<tr>). I am trying to group the rows by a pattern found in the @id attribute.

Code:

<tr id="ctl00_ContentPlaceHolder1_PICList_gridPICList__1_2_1cat" >

The pattern is the 3 characters after "ctl00_ContentPlaceHolder1_PICList_gridPICList __", which is 1_2

I tried:

Code:

<xsl:for-each-group select="//tr" group-by="substring(@id, 47 , 3)">

which provides weird results.

XSLT:

Code:

<xsl:template match="/">
    <data>
        <xsl:for-each-group select="//tr" group-by="substring(@id, 47 , 3)">
            <xsl:comment>
                <xsl:value-of select="current-grouping-key()"/>
            </xsl:comment>
        </xsl:for-each-group>
    </data>
</xsl:template>

Outputs:

Code:

<data >
    <!---->
    <!--_1c-->
    <!--_1_-->
</data>

Any suggestions would be appreciated.

Thx

samjudson · January 19th, 2010, 08:29 AM

Well in your example it looks like the substring '1_2' actually starts at character 48 - this explains the '_1_' in your sample output.

As for the others - I'm guessing that not all rows have the same number of characters before what you are trying to split on. Is it possible you could split on something else, perhaps "__"? If so then try to tokenize() function.

<xsl:for-each-group select="//tr" group-by="substring(tokenize(., '__')[2],1,3)">
...
</xsl:for-each>

bonekrusher · January 19th, 2010, 09:56 AM

Perfect. thx a lot.