How do I make group-by ignore white-space in XSLT?

Question

I have an xml file which I need to group-by using xsl:for-each-group. Everything works fine but the problem comes from when there is elements which have white space at the end of them (e.g. <word>test </word> and <word>test</word>) but I need these to be considered as one group.

Here's the sample xml file:

<u>
  <s>
    <w>this </w>
    <w>is </w>
    <w>a </w>
    <w>test </w>
  </s>
  <s>
    <w>this</w>
    <w>is</w>
    <w>a</w>
    <w>test</w>
  </s>
<u>

Here's the xslt code

<xsl:for-each-group select="bncDoc/stext/div/u/s" group-by="w" >
  <tr>  
    <td style="text-align: center;">
      <xsl:value-of select="current-grouping-key()"/>
    </td>
    <td>
      <xsl:value-of select="count(current-group())"/>
    </td>
  </tr>
</xsl:for-each-group>

Is there any workaround for this?

It would be helpful if you posted an example of the output that you are trying to produce. It is not clear whether you need to adjust your select statement or the group-by (or both). — Mads Hansen, Dec 08 '11 at 19:19

Tomalak · Accepted Answer · 2011-12-08T19:34:00.583

3

<xsl:for-each-group select="bncDoc/stext/div/u/s/w" group-by="normalize-space()">
   <!-- ... -->
</xsl:for-each-group>

edited Dec 08 '11 at 19:34

answered Dec 08 '11 at 18:35

Tomalak

332,285
67
532
628

I did it using normalize-space but I get this error: A sequence of more than one item is not allowed as the first argument of normalize-space() – Peymankh Dec 08 '11 at 18:36
@Peymankh: If there are multiple `` children, which one do you want to group on? – Tomalak Dec 08 '11 at 18:44
I want to group them based on the – Peymankh Dec 08 '11 at 19:00
@Peymankh: Yes, but apparently there is *more than one word* per group, isn't there? – Tomalak Dec 08 '11 at 19:06
Ok, I'm going to edit the question with a sample XML file, see if you can get any clue out of it. – Peymankh Dec 08 '11 at 19:11
1

@Peymankh: See modified answer. Tip for future: always include the relevant XML with your question. – Tomalak Dec 08 '11 at 19:34

score 1 · Answer 2 · answered Dec 08 '11 at 22:11

1

OK, found the answer:

You just need to use the normailize-space() in this way:

    <xsl:for-each-group select="bncDoc/stext/div/u/s/w" group-by="normalize-space((text())">
        .
        .
        .
    </xsl:for-each-group>

answered Dec 08 '11 at 22:11

Peymankh

1,976
25
30

With that `@select`, you could also just use `group-by="normalize-space()"`. What you wanted was each unique ``. It would have been helpful to mention that in the question, and Tomalak could have given you an exact answer. – Mads Hansen Dec 08 '11 at 22:33
By the way, +1 for answering your own question. – Mads Hansen Dec 08 '11 at 22:35
@Mads: That's the exactly answer I've given a few hours ago… – Tomalak Dec 08 '11 at 23:20
@Tomalak - so it is. I had seen the first version and didn't notice the edit. – Mads Hansen Dec 09 '11 at 01:28
I'm gonna leave my answer over here but will set @Tomalak's answer as the correct answer since he came up with it. – Peymankh Dec 09 '11 at 20:23

How do I make group-by ignore white-space in XSLT?

2 Answers2