Hi Experts,
I need some help formulating an XSL template that will output what I need from the attached XML file.
For each <tsfile> I need to locate the last <p> which has <id>[2] = 0.
Then return all <p>'s after the above position()
I've had a go, but I'm still learning XSLT and not having much luck.
Thanks
<?xml version="1.0" standalone="yes"?>
<h_xml_store>
<tsfile site="A">
<variable variable="200.00">
<p>
<id>1 Jan</id>
<id>20</id>
</p>
<p>
<id>2 Jan</id>
<id>0</id>
</p>
<p>
<id>3 Jan</id>
<id>1</id>
</p>
<p>
<id>4 Jan</id>
<id>2</id>
</p>
<p>
<id>5 Jan</id>
<id>0</id>
</p>
<p>
<id>6 Jan</id>
<id>1</id>
</p>
</variable>
</tsfile>
<tsfile site="B">
<variable variable="200.00">
<p>
<id>3 March</id>
<id>14</id>
</p>
<p>
<id>4 March</id>
<id>0</id>
</p>
<p>
<id>8 March</id>
<id>1</id>
</p>
<p>
<id>9 March</id>
<id>2</id>
</p>
</variable>
</tsfile>
</h_xml_store>
Open in new window
Can you suggest any good XSLT books for beginners ? I'm a c# coder and I cant get my head out of procedural mode when working on XSLT