
March 3rd, 2004, 09:36 AM
|
|
Contributing User
|
|
Join Date: Oct 2003
Posts: 40
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
|
Newbie: Consolidate Tags
I'm a total newbie to XML, so bear with me. I built an XML file to send out to a third party by manually constructing it in ASP. The XML file I've generated is about 130,000 lines and I'd like to cut it down. The format is as follows:
Code:
<data>
<Fac id="12345">
<stat type="top3Sellers">
<item>Bob Jenkins<item>
<item>John Jenkins<item>
<item>Rob Jenkins<item>
</stat>
</Fac>
</data>
Right now there are 7 seperate queries used to build the file (I know, I should use 1), but the result is that each Fac may have multiple tags. I'd like to consolidate it, so that each fac has one tag with multiple stat tags in it, rather than several Fac tags consisting of one stat tag. Is this possible using ASP/JavaScript? Keep in mind the file is not saved on the server, it is output to the browser by response.write, also performance is not an issue, as this will be run once a month on the weekends.
Thanks in advance,
Justin
|