How to remove extra space from PSV

dved · February 17th, 2009, 03:03 PM

I m trying to return a psv file ...and so my output is "text" in this case.

Here is my code:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="utf-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:strip-space elements="*"/>
<xsl:template match="paymentHistoryList">
<xsl:apply-templates></xsl:apply-templates>
</xsl:template>
<xsl:template match="paymentHistoryList">
<xsl:for-each select="paymentHistoryInfo[1]//*">
<xsl:value-of select="local-name()"/>|
</xsl:for-each>
&NL;
<xsl:for-each select="paymentHistoryInfo//*">
<xsl:value-of select="current()/text()"/>|
</xsl:for-each>
&NL;
</xsl:template>

</xsl:stylesheet>

it outputs additional new lines like under:

invoiceDate|
invoiceNumber|
previousBalance|
paymentsRecieved|
balanceForward|
currentCharges|
totalBalance|

200803|
1404813176|
135.04|
135.04|
0.0|
69.38|
69.38|
200209|
384519202|
0.0|
0.0|
0.0|
97.71|
97.71|

I want it like:
invoiceDate|invoiceNumber|previousBalance|payments Recieved|balanceForward|currentCharges|totalBalanc e|
1404813176|135.04|135.04|0.0| 69.38|...

can you help ??

mhkay · February 17th, 2009, 06:19 PM

The pipe character in the stylesheet is followed by a newline, so both have been copied to the output.

It's best to use <xsl:text>|</xsl:text> to output literal text, it gives you much better control over whitespace. That also applies to

<xsl:text>&NL;</xsl:text>

dved · February 18th, 2009, 10:52 AM

Thanks..that worked for me..

Quote:

Originally Posted by mhkay

The pipe character in the stylesheet is followed by a newline, so both have been copied to the output.

It's best to use <xsl:text>|</xsl:text> to output literal text, it gives you much better control over whitespace. That also applies to

<xsl:text>&NL;</xsl:text>