I have touble getting a certain value from a XML. I do not know it it is possble but perhaps someone can help me.
The value that I have is 'XYZ987' or 'ABC123'. In the real XML I have around 1000 <group>. There is always two <row> under each <rows>, and the first is CUST and second is PROD. However there can be one or many <col>
The value that I want to fetch is the last value under CUST, eg when using 'XYZ987' I want value 91.0 or when using 'ABC123' I want value 9.0
Is this possible?
The XML:
Code:
<group>
<header>
<row>
<col>XYZ987</col>
<col></col>
<col></col>
<col></col>
<col></col>
<col></col>
</row>
</header>
<rows>
<row>
<col>CUST</col>
<col datatype="number" decimals="0">47.0</col>
<col datatype="number" decimals="0">49.0</col>
<col datatype="number" decimals="0">16.0</col>
<col datatype="number" decimals="0">36.0</col>
<col datatype="number" decimals="0">91.0</col> <- Value I want to fetch
</row>
<row>
<col>PROD</col>
<col datatype="number" decimals="0">46.0</col>
<col datatype="number" decimals="0">41.0</col>
<col datatype="number" decimals="0">14.0</col>
<col datatype="number" decimals="0">35.0</col>
<col datatype="number" decimals="0">92.0</col>
</row>
</rows>
</group>
<group>
<header>
<row>
<col>ABC123</col>
<col></col>
<col></col>
<col></col>
<col></col>
<col></col>
</row>
</header>
<rows>
<row>
<col>CUST</col>
<col datatype="number" decimals="0">1.0</col>
<col datatype="number" decimals="0">3.0</col>
<col datatype="number" decimals="0">4.0</col>
<col datatype="number" decimals="0">7.0</col>
<col datatype="number" decimals="0">9.0</col>
</row>
<row>
<col>PROD</col>
<col datatype="number" decimals="0">46.0</col>
<col datatype="number" decimals="0">48.0</col>
<col datatype="number" decimals="0">16.0</col>
<col datatype="number" decimals="0">36.0</col>
<col datatype="number" decimals="0">91.0</col>
</row>
</rows>
</group>
Getting a value from XML using XPATH
