Hi Roy,
Thanks for the stylesheet, it works fine. I also managed to extract
default MSIE stylesheet and use as well. Although I have another
problem considering the following XML feed with variable length
infoset:
XML:
<?xml version="1.0"?>
<Data>
<Account>
<AccountNumber>1000748</AccountNumber>
<SequenceNo>1</SequenceNo>
<AccountBalance>1052.35</AccountBalance>
<Name>
<CitizenNameTitle>Mr</CitizenNameTitle>
<CitizenNameForename>Joe</CitizenNameForename>
<CitizenNameSurname>Bloggs</CitizenNameSurname>
</Name>
</Account>
<Account>
<AccountNumber>1000741</AccountNumber>
<SequenceNo>1</SequenceNo>
<AccountBalance>800.53</AccountBalance>
<Name>
<CitizenNameForename>John</CitizenNameForename>
<CitizenNameSurname>Doe</CitizenNameSurname>
</Name>
</Account>
</Data>
XSL:
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="text"/>
<xsl:template match="/">
<xsl:apply-templates select="//Account[1]/descendant::*" />
</xsl:template>
<xsl:template match="*">
<xsl:if test = "normalize-space(text())!=''" >
<xsl:value-of select = "." />
<xsl:if test = "not(position()=last())" >
<xsl:text > ,</xsl:text>
</xsl:if>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
Current output:
1000748,1,1052.35,Mr,Joe,Bloggs,1000741,1,800.53,John,Doe
Required output:
1000748,1,1052.35,Mr,Joe,Bloggs
1000741,1,800.53,,John,Doe
Any advice much appreciated.
Andrew