Attribute Names of the longest branch (Creating CSV data)

Subject: Attribute Names of the longest branch (Creating CSV data)
From: "Steve Brown" <prospect@xxxxxxxxxxx>
Date: Fri, 7 Apr 2000 16:58:33 +1000
Hi,

I am currently trying to convert tiered Xml into a CSV file.  The number of
elements/attributes and depth of the data is not known at runtime.

I can get the comma seperated data appearing fairly well currently but am
having trouble getting the column names.

eg for the data

<books>
	<book bookname="blinky bill"/>
	<book bookname="superman">
		<author name="steve" age="24"/>
	</book>
	<book bookname="snugglepot">
		<author name="frank" age="60"/>
	</book>
</books>

I want to get the output:

bookname,name,age
blinky bill
superman,steve,24
snugglepot,frank,60

I am getting the data ok, but the header line is tougher as you need to know
the longest "branch" in the data to get all of the possible column names.

Any ideas?  (remember that I will not know the shape, depth , attribute or
element names at runtime)

Thanks,

Steve


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread