Subject: [xsl] transforming a XML to CSV From: "Awasthi, Anand" <Anand_Awasthi@xxxxxxx> Date: Wed, 14 Mar 2001 11:46:53 -0600 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] ;), heavensky | Thread | Re: [xsl] transforming a XML to CS, Jeni Tennison |
RE: [xsl] Using position() with sor, Jenny Simpson | Date | Re: [xsl] Output non-XML string wit, Johannes Döbler |
Month |