[xsl] transforming a XML to CSV

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