hi i am converting from xml to csv using xsl i am getting the extra junk character(space) in the csv file.below i written the xml file and xsl file
xml file
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?xml-stylesheet type="text/xsl"?>
<DOCUMENTS>
<FILE>
<DOCUMENT>
<BUSINESS>finance</BUSINESS>
<PROGRAM>CM</PROGRAM>
<PROJECT>Testing Area</PROJECT>
<NAME>121940~1.doc</NAME>
<TEXT>SQL</TEXT>
<LINK>http://www.sql.org/</LINK>
</DOCUMENT>
<DOCUMENT>
<BUSINESS>finance</BUSINESS>
<PROGRAM>CM</PROGRAM>
<PROJECT>Testing Area</PROJECT>
<NAME>121940~1.doc</NAME>
<TEXT>Information</TEXT>
<LINK>http://google.com/</LINK>
</DOCUMENT>
<DOCUMENT>
<BUSINESS>finance</BUSINESS>
<PROGRAM>CM</PROGRAM>
<PROJECT>Testing Area</PROJECT>
<NAME>121940~1.doc</NAME>
<TEXT>Configuration</TEXT>
<LINK>http://msdn.microsoft.com/</LINK>
</DOCUMENT>
</FILE>
</DOCUMENTS>
xsl file
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text" indent="yes"/>
<xsl:template match="DOCUMENTS">
<xsl:text>Business,Program,Project,DocumentName,Textforlink,Hyperlink</xsl:text>
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="FILE">
<xsl:value-of select="DOCUMENT/BUSINESS"/>
<xsl:value-of select="','"/>
<xsl:value-of select="DOCUMENT/PROGRAM"/>
<xsl:value-of select="','"/>
<xsl:value-of select="DOCUMENT/PROJECT"/>
<xsl:value-of select="','"/>
<xsl:value-of select="DOCUMENT/NAME"/>
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="DOCUMENT">
<xsl:value-of select="','"/>
<xsl:value-of select="','"/>
<xsl:value-of select="','"/>
<xsl:value-of select="','"/>
<xsl:value-of select="TEXT"/>
<xsl:value-of select="','"/>
<xsl:value-of select="LINK"/>
</xsl:template>
</xsl:stylesheet>
for converting to csv i am using java program.
please go through it.