I want to say there's a "simple" way to sets of data from XML. For example: in the XML below, i want two records/events.. such as.
identity_id transaction_code sname dogname
3017669 SEL BARC abc123
1037669 SEL TARC pookybear
from the data set like below.
<AllRecords>
<DataSet xmlns="">
<arg token="dogname" value="abc123" />
<identity_id>3017669</identity_id>
<instrument_id>912383KM1</instrument_id>
<transaction_code>SEL</transaction_code>
<sname>BARC</sname>
<currency_code>USA</currency_code>
</DataSet>
<DataSet xmlns="">
<arg token="dogname" value="pookybear" />
<identity_id>1037669</identity_id>
<instrument_id>219383KM1</instrument_id>
<transaction_code>SEL</transaction_code>
<sname>TARC</sname>
<currency_code>USA</currency_code>
</DataSet>
</AllRecords>
Try this:
|spath|rename AllRecords.DataSet.* as *|rex max_match=0 "arg token=\"(?<token>\w+)\"\s*value=\"(?<value>\w+)"
Try this:
|spath|rename AllRecords.DataSet.* as *|rex max_match=0 "arg token=\"(?<token>\w+)\"\s*value=\"(?<value>\w+)"
sorry i forgot a field in my dataset. i also need to get "dogname" with the associated record for the row. i've updated the example above.
give this a try:
|spath|rename AllRecords.DataSet.* as *|rex max_match=0 "arg token=\"(?<token>\w+)\"\s*value=\"(?<value>\w+)"
PERFECT! The winner is "rex". That's where i need to spend more time reading apparently. Thanks for the help!
how do i accept the updated answer? or should i just accept your first one? repost as another commet and i'll accept that one.. if you want.
i have updated the answer ..please accept the answer and upvote the comment which helped