Replace some text node and sum

[karamba]

Hello,

I'm rather new in the xml world and I have a problem setting up an appropriate xslt to translate some node content into numeric values and to create a sum for each record.

Here's how the sample xml file looks like:

<record 1>	<title>title 1</title>	<note type="tags">		<note type="tag">text A</note>	</note></record><record 2>	<title>title 2</title>	<note type="tags">		<note type="tag">text A</note>		<note type="tag">text B</note>		<note type="tag">text C</note>	</note></record><record 3>	<title>title 3</title>	<note type="tags">		<note type="tag">text A</note>		<note type="tag">text C</note>	</note></record>

What I would like to do is to transform some of the "note" values into numeric values (for a database) and make one sum for each dataset.

"text A" should return "1"

"text B" should return "2"

"text C" should return "4" and so on resulting in something like this:

</Record 1><sum>1</sum></Record 1></Record 2><sum>7</sum></Record 2></Record 3><sum>5</sum></Record 3>

But I got stuck how to capture the values for each dataset for further processing, namely to create a sum for each.There is more information extracted from "note" values, which are simply compared to certain values with an <xsl: if test="contains(note, 'value')"> or <xsl: if ="starts with(note, 'value')"> outputting a numeric value as <xsl:text>. As can be seen below:

<xsl:choose>	<xsl:when test="note">		<xsl:choose>									  			<xsl:when test="contains(note, 'text y')">				<xsl:text>128</xsl:text>			</xsl:when>			<xsl:when test="contains(note, 'text z')">				<xsl:text>256</xsl:text>			</xsl:when></xsl:choose>

Could you help me? I am grateful for any suggestions.Thank you