有以下结构的xml文件 请问如何能把所有paytime中包含“2011-07-06”的trade段的payment的值存入数组或计算之和 如果可以用xml的那个udf的话 <?xml version="1.0" encoding="utf-8" ?>
<trades_sold_get_response>
<trades list="true">
<trade>
<pay_time>2011-07-06 22:35:36</pay_time>
<payment>66.00</payment>
</trade>
<trade>
<pay_time>2011-07-06 22:32:55</pay_time>
<payment>64.00</payment>
</trade>
<trade>
<pay_time>2011-07-06 22:03:05</pay_time>
<payment>41.00</payment>
</trade>
<trade>
<pay_time>2011-07-06 21:36:47</pay_time>
<payment>69.00</payment>
</trade>
</trades>
<total_results>3316</total_results>
</trades_sold_get_response>
<!-- top202085.cm3
-->
|