xml parse problem

dianbo

For the following xml string, i set

table expression "/results/result/field"
column expression "/v".

The data i get is "Jun 3 23:59:59 -lo0-0 [err] -3:2.

Is there any way to all information including those in the sub elements such as ROUTER-23, PFE etc.


<results>
<result>
<field k="_raw">
<v xml:space="preserve">
Jun 3 23:59:59
<sg h="1">ROUTER-23</sg>
-lo0-0 [err]
<sg h="1">
%
</sg>
<sg h="1">PFE</sg>
</sg>
-3:
<sg h="1">PIC</sg>
2
<sg h="1">PIO</sg>
<sg h="1">error</sg>
<sg h="1">indicated</sg>
</v>
</field>
</result>

mwilliams

Hi dianbo,

Try taking the row mapping all the way down to the 'sg' level. Then, for the column mappings, step backwards in the XML to get the values for those fields.