Hi - I've read many posts regarding getting values from XML type string field however none of them seem to work with the XML structure I am dealing with (this structure/string CANNOT be changed btw)
The string is:
<?xml version="1.0" encoding="us-ascii" standalone="yes"?><Entity label="EHCP Review Involvement"><AuditValues><value type="simple" label="Invision 360 Ref"><OldValue /><NewValue>INV0000001</NewValue></value></AuditValues></Entity>
..and I'd like to get the OldValue and the NewValue
..where the label="Invision 360 Ref"
Any help would be a life-saver !
Many thanks,
Mark