XML to CSV Using XSLT

by

Here is a version with configurable parameters that you can set programmatically:

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

  <xsl:param name="delim" select="','" />
  <xsl:param name="quote" select="'&quot;'" />
  <xsl:param name="break" select="'&#xA;'" />

  <xsl:template match="https://stackoverflow.com/">
    <xsl:apply-templates select="projects/project" />
  </xsl:template>

  <xsl:template match="project">
    <xsl:apply-templates />
    <xsl:if test="following-sibling::*">
      <xsl:value-of select="$break" />
    </xsl:if>
  </xsl:template>

  <xsl:template match="*">
    <!-- remove normalize-space() if you want keep white-space at it is --> 
    <xsl:value-of select="concat($quote, normalize-space(), $quote)" />
    <xsl:if test="following-sibling::*">
      <xsl:value-of select="$delim" />
    </xsl:if>
  </xsl:template>

  <xsl:template match="text()" />
</xsl:stylesheet>

More Related Contents:

  1. XSLT 2.0 to convert CSV to XML format
  2. XSLT Transform doesn’t work until I remove root node
  3. Can Chrome be made to perform an XSL transform on a local file?
  4. How to save newlines in XML attribute?
  5. How to force wrap on table entries
  6. split function in xslt 1.0
  7. XSLT: How to convert XML Node to String
  8. XSLT: A simple way to merge xml files
  9. XPath with multiple conditions
  10. Removing duplicate elements with XSLT
  11. Add CDATA to an xml file
  12. How to mimic copy-namespaces=”no” in XSLT 1.0?
  13. Finding the difference between two dateTimes in XSLT
  14. How to unescape XML characters with help of XSLT?
  15. how to Merge two xml files with XSLT
  16. XSLT Replace function not found
  17. What is the difference between ‘or’ and ‘|’ when programming in xslt?
  18. XSL xsl:template match=”/”
  19. Concatenate multiple node values in xpath
  20. how to find the current date in XSLT 1.0
  21. Preserving entity references when transforming XML with XSLT?
  22. WiX Installer: using xslt with heat.exe to update attributes
  23. In XSLT how do you test to see if a variable exists?
  24. How to use node-set function in a platform-independent way?
  25. Need help in creating XSLT, i do have Source and Target XML
  26. What’s the best way to export UTF8 data into Excel?
  27. Including an XML file in an XML/XSL file
  28. XSLT: Select following-sibling until reaching a specified tag
  29. XSLT Transformation – dynamic element names
  30. Converting XML elements to XML attributes using XSLT

Leave a Comment