I have the following XML and would like to get the name and it's value back:
<?xml version="1.0" encoding="UTF-8"?>
<company>
<name>Company A</name>
<values>
<value>20000</value>
</values>
<name>Company B</name>
<values>
<value>40000</value>
</values>
</company>
I'm looking for a XPATH that give me something like the following back:
Company A : 20000 Company B : 40000
Any ideas? Is there a function for this?