XML to read bank statement

[EDN Admin]

Can anyone help? The following code reads a bank statement file, returns the debit value from column 7 true false element (works OK), returns the credit value from column 6 and inverts. As you can see from the code, I need it to look up value "DR" in column
3 and return column 6 value inverted. This works but only for one instance. Where there are several rows of DR, the code returns only one!
<?xml version="1.0" encoding="utf-8"?><br/>
<Root><br/>
<Name>Import Format</Name><br/>
<If><br/>
<Operator name="GreaterThan <br/>
<Value>Line</Value><br/>
<Value>2</Value><br/>
</Operator><br/>
<Fields><br/>
<Field name="Statement Balance <br/>
<Functions><br/>
<Func name="GetColumn" column="8" /><br/>
</Functions><br/>
</Field><br/>
<Field name="Transaction Reference <br/>
<Functions><br/>
<Func name="GetColumn" column="4" /><br/>
</Functions><br/>
</Field><br/>
<Field name="Transaction Date <br/>
<Functions><br/>
<Func name="GetColumn" column="2" /><br/>
</Functions><br/>
</Field><br/>
<Field name="Transaction Value <br/>
<Functions><br/>
<Func name="Pick
<br/>
<Operator name="Equal <br/>
<Func name="Upp <br/>
<Func name="GetColumn" column="3" /><br/>
</Func><br/>
<Value>DR</Value> <br/>
</Operator><br/>
<Operator name="Mult If I omit the
<span style="text-decoration:underline mult Operator and
<span style="text-decoration:underline Value -1 lines, all DR values are returned <br/>
<Func name="GetColumn" column="6" /><br/>
<Value>-1</Value><br/>
</Operator><br/>
<Func name="GetColumn" column="7" /> <br/>
</Func>
<br/>
</Functions><br/>
</Field><br/>
<Field name="Transaction Type <br/>
<Functions><br/>
<Func name="GetColumn" column="3" /><br/>
</Functions><br/>
</Field><br/>
</Fields><br/>
</If><br/>
</Root>

Thank you<br/>


<br/>
<br/>

View the full article