Subject: Re: [xsl] Sum in conjunction with string splitting? From: "Dimitre Novatchev" <dnovatchev@xxxxxxxxx> Date: Fri, 8 Sep 2006 10:53:06 -0700 |
Posted yesterday, but I isolated the problem significantly =)
The snippet below attempts to split the string 'mileage 6' into [mileage] and [6] and then store it in $miles (for example).
I am trying to get the SUM of the resulting SPLIT of the nodes that match 'mileage'.
I am close. Right now I only get one node, not the sum of all matches.
<xsl:variable name="miles"> <xsl:call-template name="str-split-to-words"> <xsl:with-param name="pStr" select="msxsl:node-set($expenses[substring(expense,1,7)='mileage']/expense)" /> <xsl:with-param name="pDelimiters" select="' '" /> <!-- splitting expense at blank spaces --> </xsl:call-template> </xsl:variable> <xsl:value-of select="msxsl:node-set($miles)/*[2]" /><br />
====
$expenses example:
<Expenses> <expense>Mileage 6</expense> <expense>cheese</expense> (wouldn't match) <expense>Mileage 10</expense> </Expenses>
====
Desired value of $miles: 16.
sum(f:map(f:compose(f:decimal(), f:flip(f:substring-after(),' ') ), /*/*[contains(.,' ')] ) )
f:transform-and-sum(f:flip(f:substring-after(),' '), /*/*[contains(.,' ')] )
-- Cheers, Dimitre Novatchev --------------------------------------- Truly great madness cannot be achieved without significant intelligence. --------------------------------------- To invent, you need a good imagination and a pile of junk
Thanks a bunch,
-Steve
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Sum in conjunction with strin, Steve | Thread | Re: [xsl] Sum in conjunction with s, Steve |
Re: [xsl] Relationships in for-each, Bob Portnell | Date | [xsl] How expensive is //?, Steve |
Month |