[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] transforming a XML to CSV
Hi, I am trying to transform the following XML file in to a comma separated file (.csv). <REPORT_ITEM> <HEADER> <REPORT>Venkatesh</REPORT> <SYSTEM>OASIS</SYSTEM> <TZ>PPT</TZ> <MKT_TYPE>R</MKT_TYPE> <SCHED_CLASS/> <UOM>US$</UOM> <INTERVAL>ENDING</INTERVAL> <SEC_PER_INTERVAL>3600</SEC_PER_INTERVAL> </HEADER> <DATA> <DATA_ITEM>SPIN_PRICE</DATA_ITEM> <SOURCE/> <SINK/> <RESOURCE>ZP26</RESOURCE> <OPR_DATE>20000512</OPR_DATE> <INTERVAL_NUM>24</INTERVAL_NUM> <NULL_FLAG>F</NULL_FLAG> <VALUE>0.25</VALUE> </DATA> <DATA> <DATA_ITEM>SPIN_PRICE</DATA_ITEM> <SOURCE/> <SINK/> <RESOURCE>ZP26</RESOURCE> <OPR_DATE>20000512</OPR_DATE> <INTERVAL_NUM>25</INTERVAL_NUM> <NULL_FLAG>T</NULL_FLAG> <VALUE/> </DATA> </REPORT_ITEM> <REPORT_ITEM> <HEADER> <REPORT>Parigi</REPORT> <SYSTEM>OASIS</SYSTEM> <TZ>PPT</TZ> <MKT_TYPE>D</MKT_TYPE> <SCHED_CLASS/> <UOM>MW</UOM> <INTERVAL>ENDING</INTERVAL> <SEC_PER_INTERVAL>3600</SEC_PER_INTERVAL> </HEADER> <DATA> <DATA_ITEM>SPIN_PRICE</DATA_ITEM> <SOURCE/> <SINK/> <RESOURCE>ZP26</RESOURCE> <OPR_DATE>20000512</OPR_DATE> <INTERVAL_NUM>24</INTERVAL_NUM> <NULL_FLAG>F</NULL_FLAG> <VALUE>0.25</VALUE> </DATA> <DATA> <DATA_ITEM>SPIN_PRICE</DATA_ITEM> <SOURCE/> <SINK/> <RESOURCE>ZP26</RESOURCE> <OPR_DATE>20000512</OPR_DATE> <INTERVAL_NUM>25</INTERVAL_NUM> <NULL_FLAG>T</NULL_FLAG> <VALUE/> </DATA> </REPORT_ITEM> the kind of output which i am trying to achieve is something like : ( i want HEADER ELEMENT to repeat with all DATA_ITEM ELELMENTS ) Venkatesh,1,US$,SPIN_PRICE,,,ZP26,20000512,24,F,0.25 Venkatesh,1,US$,SPIN_PRICE,,,ZP26,20000512,25,T Parigi,2,MW,SPIN_PRICE,,,ZP26,20000512,24,0.25 Parigi,2,MW,SPIN_PRICE,,,ZP26,20000512,25,T could someone please help me ?? thanks Anand XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|