XML to CSV using XSL template

Question

I got this simple XML document:

<?xml version="1.0"?>
<document>
<category>
    <id>20504       </id>
    <title>ADSL iranga</title>
    <parent>Kompiuterinio tinklo</parent>
</category>
<category>
    <id>20902</id>
    <title>Akumuliatoriai</title>
    <parent>Baterijos akumuliatoriai</parent>
</category>
</document>

And this xsl template:

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

<xsl:template match="/category">
  <xsl:value-of select="id" /><xsl:text>,</xsl:text>
  <xsl:value-of select="title" /><xsl:text>,</xsl:text>
</xsl:template>


</xsl:stylesheet>

I would like to get this simple output:

id,title
id,title
id,title
<...>

However, I don't get my expected delimiter "," Am I using the xsl:text in some wrong manner?

I am using xsltproc for the conversion.

michael.hor257k · Accepted Answer · 2016-07-28 00:15:53Z

2

category is not the root element of your input XML - so your template matches nothing, and the output you see is produced by the built-in template rules.

You need to change:

<xsl:template match="/category">

to:

<xsl:template match="category">

I think you also want to change the second:

<xsl:text>,</xsl:text>

to:

<xsl:text>&#10;</xsl:text>

answered Jul 28, 2016 at 0:15

michael.hor257k

118k6 gold badges36 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

XML to CSV using XSL template

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related