[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Generating a CSV file using XSLT
Tempore 14:45:37, die 02/09/2005 AD, hinc in
xsl-list@xxxxxxxxxxxxxxxxxxxxxx scripsit Ian Vaughan
<i.vaughan@xxxxxxxxxxxxxxxxxxxxxxx>:
Any idea of how I could transform the XML doc into the following layout below in the csv file ?? The way to the best solution depends on the XML. When no information is provided, are the elements then missing or do they have no text node children? If I may assume the latter, you might try this: <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:text>UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems </xsl:text> <xsl:apply-templates select="//BuildingRecord"/> </xsl:template> <xsl:template match="BuildingRecord"> <xsl:apply-templates select=".//*[not(*)] | .//apd:*/*"/> <xsl:text> </xsl:text> </xsl:template> <xsl:template match="BuildingRecord//* | apd:*/* "> <xsl:if test="position() > 1 ">,</xsl:if> <xsl:value-of select="normalize-space(.)"/> </xsl:template> </xsl:stylesheet> produces: UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems 2,02,Name,Street Name,,,Town,SA128JW,20/01/2005,Shower,New Unit the field names are generated automatically here, if you prefer hard coding them, just omit all templates with mode set to 'label'.
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|