This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
transforming a XML to CSV
- To: "'xsl-list at lists dot mulberrytech dot com'" <xsl-list at lists dot mulberrytech dot com>
- Subject: [xsl] transforming a XML to CSV
- From: "Awasthi, Anand" <Anand_Awasthi at bmc dot com>
- Date: Wed, 14 Mar 2001 11:46:53 -0600
- Reply-To: xsl-list at lists dot mulberrytech dot com
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