Re: Grouping and counting values in an element

Thanks for your reply, but sorry, cause I am still a newbie.
How do you concatenate all the Payment_Pattern that comes back ?
Can you show me an example please ? thx

From: Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re: Grouping and counting values in an element
Date: Mon, 16 Aug 2004 15:32:41 -0400
MIME-Version: 1.0
X-Sender: wapiez@xxxxxxxxxxxxx
Received: from h01.biglist.com ([209.123.46.101]) by mc3-f3.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 16 Aug 2004 12:46:12 -0700
Received: (qmail 95104 invoked by uid 2149); 16 Aug 2004 19:46:01 -0000
Received: (qmail 95089 invoked from network); 16 Aug 2004 19:46:01 -0000
X-Message-Info: JGTYoYF78jEqtIvqinRlMZ9R2A+A9jmN
Mailing-List: contact xsl-list-help@xxxxxxxxxxxxxxxxxxxxxx
Precedence: bulk
X-BL-Legal-Notice: <http://www.BIGLIST.com/legal/>
X-Complaints-To: <mailto:abuse@xxxxxxxxxxx>
List-Post: <mailto:xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
List-Help: <mailto:xsl-list-help@xxxxxxxxxxxxxxxxxxxxxx>
List-Unsubscribe: <mailto:xsl-list-unsubscribe-excel_man=hotmail.com@xxxxxxxxxxxxxxxxxxxxxx>
List-Subscribe: <mailto:xsl-list-subscribe@xxxxxxxxxxxxxxxxxxxxxx>
Delivered-To: mailing list xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Message-Id: <6.0.0.22.0.20040816152829.02d98178@xxxxxxxxxxxxx>
X-Mailer: QUALCOMM Windows Eudora Version 6.0.0.22
In-Reply-To: <BAY9-F19839xjQ0BwSN0002f1cd@xxxxxxxxxxx>
References: <BAY9-F19839xjQ0BwSN0002f1cd@xxxxxxxxxxx>
Return-Path: xsl-list-return-4708-excel_man=hotmail.com@xxxxxxxxxxxxxxxxxxxxxx
X-OriginalArrivalTime: 16 Aug 2004 19:46:13.0125 (UTC) FILETIME=[AF9E0350:01C483C9]

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