xsl-list
[Top] [All Lists]

AW: XML Query!

2003-01-10 04:36:21
Hello Rakesh,

I hope not, otherwise I spent a few days wasting my time before Xmas :-)

I had a need also to create CSV from XML and with the help of the many
"unsung heroes" in xsl-list, whose patience and willingness to share
knowledge amazes me at times, I managed to do what I needed. Here's a piece
of what I ended up with. You'll have to change it to suit your needs but it
does the basics. It only extracts the element and attribute values of "leaf
nodes" (descendants that don't have children). The seperator is currently a
"!". 

Hope it helps.

############################
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
        <xsl:output method="text"/>
        <xsl:template match="xyz">
                        <xsl:for-each select="(.//*[not(*)]|.//@*)"
                                <xsl:value-of select="."/>      
                                <xsl:if test="position()!=last()">!</xsl:if>

                        </xsl:for-each> 
                        <xsl:text>&#10;</xsl:text>

        </xsl:template>
    </xsl:stylesheet>
############################


Cheers,

Robin
                                                     
Robin Delaney
FJA Feilmeier & Junker GmbH                 
web  http://www.fja.com

-----Ursprüngliche Nachricht-----
Von:  Rakesh Seth [SMTP:RakeshSeth(_at_)mastek(_dot_)com]
Gesendet am:  Freitag, 10. Januar 2003 11:08
An:   xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Betreff:      [xsl] XML Query!

Hi
I want to convert XML data into a csv file.Is there any parser available
for that?

Rakesh Sheth
rakeshseth(_at_)mastek(_dot_)com
rakeshsheth(_at_)go(_dot_)com
Tel.No.-6952222
Extn.No.-1122
Tel.No.(Resi.)-3802293




MASTEK
Investing in relationships
In the US, we're called MAJESCO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions expressed in this e-mail are those of the individual and not that
of Mastek Limited, unless specifically indicated to that effect. Mastek
Limited does not accept any responsibility or liability for it. This
e-mail and attachments (if any) transmitted with it are confidential
and/or privileged and solely for the use of the intended person or entity
to which it is addressed. Any review, re-transmission, dissemination or
other use of or taking of any action in reliance upon this information by
persons or entities other than the intended recipient is prohibited. This
e-mail and its attachments have been scanned for the presence of computer
viruses. It is the responsibility of the recipient to run the virus check
on e-mails and attachments before opening them. If you have received this
e-mail in error, kindly delete this e-mail from all computers.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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

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



<Prev in Thread] Current Thread [Next in Thread>
  • AW: XML Query!, Delaney Robin <=