Re: [xsl] Transforming tabular information to hierarchical

Subject: Re: [xsl] Transforming tabular information to hierarchical
From: "Andrew Welch" <andrew.j.welch@xxxxxxxxx>
Date: Tue, 13 Feb 2007 16:59:15 +0000
On 2/13/07, Simon Shutter <simon@xxxxxxxxxxx> wrote:
If I have a tabular data set that defines parent-child relationships, is it
possible to transform this into a hierarchical tree format using XSLT?

Here's a csv to XML converter I wrote the other day, feel free to convert it to use tabs, or adjust your input to be comma delimited.

<xsl:stylesheet version="2.0" xmlns:xsl=""; xmlns:xs=""; exclude-result-prefixes="xs">

<xsl:output indent="yes" encoding="US-ASCII"/>

<xsl:param name="pathToCSV" select="'file:///c:/temp/test.csv'"/>

<xsl:template name="main">
		<xsl:when test="unparsed-text-available($pathToCSV)">
			<xsl:variable name="csv" select="unparsed-text($pathToCSV)"/>
			<xsl:variable name="lines" select="tokenize($csv, '&#xa;')" as="xs:string+"/>
			<xsl:variable name="elemNames" select="tokenize($lines[1], ',')"
				<xsl:for-each select="$lines[position() > 1]">
						<xsl:variable name="lineItems"
select="tokenize(normalize-space(.), ',')" as="xs:string+"/>
						<xsl:for-each select="$elemNames">
							<xsl:variable name="pos" select="position()"/>
							<xsl:element name="{normalize-space(.)}">
								<xsl:value-of select="$lineItems[$pos]"/>
			<xsl:text>Cannot locate : </xsl:text><xsl:value-of select="$pathToCSV"/>

Current Thread