Re: [xsl] Grouping and counting values in an element

[Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>]

Hi Cezar,

Given a Payment_Pattern as the current node,

  <xsl:value-of select="string-length(.) - 
string-length(translate(.,'2','')"/>

would tell you how many occurrences of '2' are in the string. (Subtract the 
length of the string with the 2s removed from the length of the full string.)

If by "in all the records" you mean all the Payment_Pattern elements 
together, they could be concatenated and the same operation performed on 
the resulting mega-string.

Cheers,
Wendell

At 03:35 PM 8/16/2004, you wrote:
> Dear all,
>
> I got a problem.
> <Trades>
>  <record>
>  <Payment_Pattern>111111111111111</Payment_Pattern>
>  </record>
>  <record>
>  <Payment_Pattern>112224443311111</Payment_Pattern>
>  </record>
>  <record>
>  <Payment_Pattern>1112211111133311</Payment_Pattern>
>  </record>
> </trades>
>
> The question is how do you get the number of 2's (or 1's or 3's)  in all 
> the records ?
> Any help will be appreciated, thx
>
> Cezar
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
> http://join.msn.com/?page=features/junkmail


======================================================================
Wendell Piez                            mailto:wapiez@xxxxxxxxxxxxxxxx
Mulberry Technologies, Inc.                http://www.mulberrytech.com
17 West Jefferson Street                    Direct Phone: 301/315-9635
Suite 207                                          Phone: 301/315-9631
Rockville, MD  20850                                 Fax: 301/315-8285
----------------------------------------------------------------------
  Mulberry Technologies: A Consultancy Specializing in SGML and XML
======================================================================