This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

converting XML to comma-separated value text file


I've been surfing the web for a couple hours, but can't find a basic
discussion of how to convert XML to a CSV text file.
(My background:  I have modified pre-existing XSL stylesheets to convert
the following type of XML into HTML.)  Thanks!

The  XML looks like this:

<dssgrid ns="A">
<style-info StyleID="YB0450EDB225F11D292DC00C04FEDC18B" DispWidth="-1"
GridPadChar="32" GridColSep="32" GridOverflowColSep="9" NewLine="13"
GridSpace="32"></style-info>

<attr n="1" url="Product+Line">Product Line</attr>

<column-header>
     <upper-left rows="1">Product Line</upper-left>
     <mh n="1" cols="1">Daily</mh>
     <mh n="2" cols="1">Todays Cedits</mh>
     <mh n="3" cols="1">MTD</mh>
     <mh n="4" cols="1">Average Daily Sales</mh>
</column-header>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="CO" idurl="CO">Colwell</ae-desc>
     </row-header>
     <mv n="1" uf="-6816.2">($6,816.20)</mv>
     <mv n="2" uf="-206.2">($206.20)</mv>
     <mv n="3" uf="-109294.52">($109,294.52)</mv>
     <mv n="4" uf="-5464.726">($5,464.73)</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="EQ" idurl="EQ">Equipment</ae-desc>
     </row-header>
     <mv n="1" uf="7671">$7,671.00</mv>
     <mv n="2" uf="-16676">($16,676.00)</mv>
     <mv n="3" uf="654653.59">$654,653.59</mv>
     <mv n="4" uf="32732.6795">$32,732.68</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="ES" idurl="ES">Eaglesoft</ae-desc>
     </row-header>
     <mv n="1" uf="13510">$13,510.00</mv>
     <mv n="2" uf=""></mv>
     <mv n="3" uf="112417.91">$112,417.91</mv>
     <mv n="4" uf="5620.8955">$5,620.90</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="GO" idurl="GO">Gold</ae-desc>
     </row-header>
     <mv n="1" uf=""></mv>
     <mv n="2" uf=""></mv>
     <mv n="3" uf="228.95">$228.95</mv>
     <mv n="4" uf="11.4475">$11.45</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="PS" idurl
="PS">Parts/Service</ae-desc>
     </row-header>
     <mv n="1" uf="286">$286.00</mv>
     <mv n="2" uf="-976.85">($976.85)</mv>
     <mv n="3" uf="158187.5">$158,187.50</mv>
     <mv n="4" uf="7909.375">$7,909.38</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="SU" idurl="SU">Sundries</ae-desc>
     </row-header>
     <mv n="1" uf="79083.19">$79,083</mv>
     <mv n="2" uf="-11319.22">($11,319.22)</mv>
     <mv n="3" uf="1807683.51">$1,807,683.51</mv>
     <mv n="4" uf="90384.1755">$90,384.18</mv>
</row>

<row>
     <row-header>
          <ae-desc n="1" rows="1" idval="TE" idurl="TE">Teeth</ae-desc>
     </row-header>
     <mv n="1" uf="2159.21">$2,159.21</mv>
     <mv n="2" uf="-129.45">($129.45)</mv>
     <mv n="3" uf="40836.17">$40,836.17</mv>
     <mv n="4" uf="2041.8085">$2,041.81</mv>
</row>

<row>
     <row-header>
          <gt-header cols="1"></gt-header>
     </row-header>
     <gt>
          <mv n="1" uf="109525.6">$109,525.60</mv>
     </gt>
     <gt>
          <mv n="2" uf="-29307.72">($29,307.72)</mv>
     </gt>
     <gt>
          <mv n="3" uf="2883302.15">$2,883,302.15</mv>
     </gt>
     <gt>
          <mv n="4" uf="-144165.1075">($144,165.11)</mv>
     </gt>
</row>

</dssgrid>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]