Re: Grouping and counting values in an element

Play the video

Subject: Re: Grouping and counting values in an element
From: Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>
Date: Mon, 16 Aug 2004 15:32:41 -0400

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

Current Thread
Grouping and counting values in an element john lee - 16 Aug 2004 19:36:45 -0000 Wendell Piez - 16 Aug 2004 19:46:21 -0000 <= <Possible follow-ups> john lee - 16 Aug 2004 20:23:54 -0000 Wendell Piez - 16 Aug 2004 20:58:20 -0000

<- Previous	Index	Next ->
Grouping and counting values , john lee	Thread	Re: Grouping and counting val, john lee
Grouping and counting values , john lee	Date	Split HTML File Into XML and , Trevor Majic
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >