xsl-list
[Top] [All Lists]

Re: Grouping and counting values in an element

2004-08-16 12:32:41
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


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


======================================================================
Wendell Piez                            
mailto:wapiez(_at_)mulberrytech(_dot_)com
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
======================================================================



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