summing nos in string

thaqi498 · March 6th, 2012, 07:27 AM

Hello all,

I have strings like

string:1
string:2
string:31

etc

I want to sum of the numbers in it

using xslt

Martin Honnen · March 6th, 2012, 07:42 AM

Well with XSLT/XPath 2.0 you can do e.g.

Code:

sum(for $s in ('string:1', 'string:2', 'string:31') return xs:integer(substring-after($s, ':')))

thaqi498 · March 6th, 2012, 09:27 AM

Thanks for the reply,
but I need the solution for xslt 1.0 version

samjudson · March 6th, 2012, 09:33 AM

2 ways.

In pure XSLT 1.0 you could write a recursive template, that takes a set of nodes, parses the first one, and then passes the rest into the template again, returning the first node value, plus whatever is returned by the recursive call.

Or you could parse the nodes once, then feed the resulting nodeset into a variable, which is then summed. To do this you would have to use something like exsl:node-set().

thaqi498 · March 6th, 2012, 09:38 AM

can you please provide me some sample code in 1.0

Martin Honnen · March 6th, 2012, 09:52 AM

Consider to post a sample of the XML you have as the input first.