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

["john lee" <excel_man@xxxxxxxxxxx>]

Dear Wendell,

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

Cezar

> From: Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>
> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: Re: [xsl] 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
> ======================================================================

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail