How to sum if we have multi condition?

rympet · March 17th, 2011, 05:37 AM

Hi all,
i have to sum elements in fields which are in substring(field[@id='0'], 9,2). But where is some condition I should to check if substring(field[@id='0'], 1,3)='MAR' and substring(field[@id='0'],12,4)='0010'). so of my example we should get answer '25'.

Code:

<document>
	<line id="0">
		<field id="0"><![CDATA[MAR6477 11 0010]]></field>
	</line>
	<line id="1">
		<field id="0"><![CDATA[MAR6477 12 0020]]></field>
	</line>
	<line id="2">
		<field id="0"><![CDATA[MAR6477 14 0010]]></field>
	</line>
</document>

What is the simplest decision to sum it?

mhkay · March 17th, 2011, 05:54 AM

Summing over computed values in XSLT 2.0 is easy, for example

Code:

sum(for $x in line/field return number(substring(., 9, 2)))

In XSLT 1.0 it's much harder. See for example http://www.biglist.com/lists/xsl-lis.../msg00968.html