Convert XML to CSV using XSLT

Question

Convert the XML into CSV using XSLT transformation

<start>
<article>
<key>key1</key>

<definition type="m">
<![CDATA[abcdefghijk]]>
</definition>
</article>

<article>
<key>key2</key>

<definition type="m">
<![CDATA[bcdefghijkl]]>
</definition>
</article>
</start>

csv will look like

key1,abcdefghijk
key2,bcdefghijkl

I'v learn w3c school xslt tutorial,but can't get practice. Can someone write XSLT code for transformation?

I think this can help you: stackoverflow.com/questions/365312/xml-to-csv-using-xslt — Morten Frederiksen
– Morten Frederiksen, Commented Sep 3, 2011 at 17:02

Emiliano Poggi · Accepted Answer · 2011-09-03 20:46:25Z

1

You can achieve the wanted result with a single template:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text"/>
    <xsl:strip-space elements="*"/>

    <xsl:template match="start/article">
        <xsl:if test="position()>1">
            <xsl:text>&#xA;</xsl:text>
        </xsl:if>
        <xsl:value-of select="normalize-space(
            concat(key,'; ',definition))"/>
    </xsl:template>

</xsl:stylesheet>

answered Sep 3, 2011 at 20:46

Emiliano Poggi

24.9k8 gold badges58 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kirill Polishchuk · Accepted Answer · 2011-09-03 18:14:29Z

0

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" indent="yes"/>

  <xsl:template match="/">
    <xsl:apply-templates select="//article/*"/>
  </xsl:template>

  <xsl:template match="key">
    <xsl:copy-of select="normalize-space(concat(., ';'))"/>
  </xsl:template>

  <xsl:template match="definition">
    <xsl:copy-of select="normalize-space(.)"/>
    <xsl:text>&#xD;&#xA;</xsl:text>
  </xsl:template>

</xsl:stylesheet>

answered Sep 3, 2011 at 18:14

Kirill Polishchuk

56.4k11 gold badges125 silver badges127 bronze badges

Collectives™ on Stack Overflow

Convert XML to CSV using XSLT

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related