Re: Generating a CSV file using XSLT

Tempore 12:10:20, die 02/09/2005 AD, hinc in  
xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com scripsit Ian Vaughan  
<i(_dot_)vaughan(_at_)neath-porttalbot(_dot_)gov(_dot_)uk>:
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
>  version="1.0">
> <xsl:output method="text"/>
> <xsl:template match="BuildingRecord">
> <xsl:value-of select="normalize-space(SchemeUniqueRecordIdentifier)"/>,
> <xsl:value-of
> select="normalize-space(CompetentPerson/PersonRegistrationNumber)"/>,
> <xsl:value-of
> select="normalize-space(CompetentPerson/InstallerRegisteredName)"/>,
> <xsl:value-of
> select="normalize-space(WorkPerformed/PropertyInformation/PropertyLocati
> on/PropertyAddress/)"/>,
> <xsl:value-of
> select="normalize-space(WorkPerformed/DateWorkCompleted)"/>,
> <xsl:value-of
> select="normalize-space(WorkPerformed/DescriptionOfWorkItem)"/>,
> </xsl:template>
> </xsl:stylesheet>
Hi,

Maybe you could make more use of templates to get the same result:

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:apd="http://www.govtalk.gov.uk/people/AddressAndPersonalDetails";>

<xsl:template match="/">
        <xsl:apply-templates select="//BuildingRecord"/>
</xsl:template>

<xsl:template match="BuildingRecord">
        <xsl:apply-templates select=".//text()"/>
        <xsl:text>
        </xsl:text>
</xsl:template>

<xsl:template match="text()">
        <xsl:if test="position() &gt; 1 "><xsl:text>,</xsl:text></xsl:if>
        <xsl:value-of select="normalize-space(.)"/>
</xsl:template>

<xsl:template match="apd:*//text()">
        <xsl:value-of select="normalize-space(.)"/><xsl:text> </xsl:text>
</xsl:template>

</xsl:stylesheet>


output:

2,02,NameStreet Name Town SA128JW ,20/01/2005,Shower,New Unit



regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-view.cgi?userid=38041)
"Et ipsa scientia potestas est"  - Francis Bacon , Meditationes sacrae

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--