sample data
<MAINNODE>
<NODE1 ID="C1" DATE="2018-11-16 09:20:01">
<NODE2>
<NODE3 CODE="A1" AMOUNT="100"/>
<NODE3 CODE="A2" AMOUNT="200"/>
<NODE3 CODE="A3" AMOUNT="300"/>
</NODE2>
</NODE1>
<NODE1 ID="C2" DATE="2018-11-16 09:20:01">
<NODE2>
<NODE3 CODE="A2" AMOUNT="100"/>
<NODE3 CODE="A1" AMOUNT="200"/>
</NODE2>
</NODE1>
</MAINNODE>
Can you please help me out to build a regular expression or any other method (ex: xpath) to get the rows as mentioned below.
ID="C1", DATE="2018-11-16 09:20:01", CODE="A1", AMOUNT="100"
ID="C1", DATE="2018-11-16 09:20:01", CODE="A2", AMOUNT="200"
ID="C1", DATE="2018-11-16 09:20:01", CODE="A3", AMOUNT="300"
ID="C2", DATE="2018-11-16 09:20:01", CODE="A2", AMOUNT="100"
ID="C2", DATE="2018-11-16 09:20:01", CODE="A1", AMOUNT="200"
... View more