Subject: [xsl] converting XML to comma-separated value text file From: Kevin.Wilson@xxxxxxxxxxxxxxxxxxx Date: Tue, 19 Jun 2001 14:49:57 -0500 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] fo:character, Carmelo Montanez | Thread | Re: [xsl] converting XML to comma-s, Bob DuCharme |
RE: [xsl] Re: Any Doc to XML conver, Pavek, Gary | Date | Re: [xsl] Remove a quote in a strin, Bob DuCharme |
Month |