xsl-list
[Top] [All Lists]

RE: conditional count

2004-10-20 03:37:01
Thanks Ken and Mukul.

I only tried the first solution and the idea worked out fine.
Actually I realized that I needed to filter all empty elements and elements
containing one or more empty elements or one or more 0-value elements.

I therefore used not(/root/row[column[.=0]) and
not(/root/row[column[normalize-space(.)=''])

Thanks for the fast reply guys!

Sincerely
Daniel

-----Original Message-----
From: G. Ken Holman [mailto:gkholman(_at_)CraneSoftwrights(_dot_)com] 
Sent: 19. oktober 2004 19:01
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] conditional count


At 2004-10-19 18:07 +0200, Daniel Heskia wrote:
I can filter out the empty "row"'s by challenging the contents of the 
entire element by: <xsl:value-of 
select="count(/root/row[normalize-space()])"/>

But how do I exclude an element "row" if just a single "column" in the 
element is empty?

For "exclude those with at least one empty column":

    count(/root/row[not(column[not(normalize-space())])])
    "count rows without columns without space"

For "exclude those with exactly one empty column":

    count(/root/row[not(count(column[not(normalize-space())]=1))])
    "count rows without a single column without space"

I hope this helps.

.......................... Ken

<root>
<row>
  <column>Peter</column>
  <column>Johnson</column>
  <column>High Street 10</column>
  <column>Male</column>
  <column>15-10-2004</column>
  <column>13.11</column>
  </row>
<row>
  <column></column>
  <column></column>
  <column></column>
  <column></column>
  <column></column>
  <column></column>
  </row>
<row>
  <column>Sue</column>
  <column>Bond</column>
  <column>Dollar Avenue</column>
  <column>Female</column>
  <column>01-05-2003</column>
  <column></column>
</row>
</root>


--
World-wide on-site corporate, govt. & user group XML/XSL training.
G. Ken Holman                 mailto:gkholman(_at_)CraneSoftwrights(_dot_)com
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
Box 266, Kars, Ontario CANADA K0A-2E0    +1(613)489-0999 (F:-0995)
Male Breast Cancer Awareness  http://www.CraneSoftwrights.com/s/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal


--+------------------------------------------------------------------
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>
--+--




<Prev in Thread] Current Thread [Next in Thread>