Restructuting XML Data

Posted by Frank on Stack Overflow See other posts from Stack Overflow or by Frank
Published on 2010-06-10T14:58:14Z Indexed on 2010/06/10 15:02 UTC
Read the original article Hit count: 351

Filed under:

Xml

|

xsl

Hi!

The following is an excerpt of my XML data source:

<file>
<ALL_INSTANCES>
<instance>
<ID>1</ID>
<start>5.8633333333</start>
<end>29.8216666667</end>
<code>Player 1</code>
</instance>
<instance>
<ID>2</ID>
<start>28.4566666667</start>
<end>51.1450000000</end>
<code>Player 2</code>
</instance>
<instance>
<ID>3</ID>
<start>49.8383333333</start>
<end>71.1150000000</end>
<code>Player 3</code>
</instance>
<instance>
<ID>4</ID>
<start>72.9850000000</start>
<end>95.3766666667</end>
<code>Speler 1</code>
</instance>
</ALL_INSTANCES>

I'm looking to restructure this data into something like this:

<Player 1>
    <ID>1</ID>
    <start>5.8633333333</start>
    <end>29.8216666667</end>
</Player 1>
<Player 1>
    <ID>4</ID>
    <start>72.9850000000</start>
    <end>95.3766666667</end>
</Player 1>
<Player 2>
    <ID>2</ID>
    <start>28.4566666667</start>
    <end>51.1450000000</end>
</Player 2>
<Player 3>
    <ID>3</ID>
    <start>49.8383333333</start>
    <end>71.1150000000</end>
</Player 3>

Could anyone please help me to achieve this? Much appreciated!

Cheers, Frank

© Stack Overflow or respective owner

Related posts about Xml

Store XML,update record in XML,retrive a specific record in XML stored on BB device

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a blackberry application where i want to store the data returned by a web service in my BB device.Earlier i was going to use SQLite for storing the data in mobile but as i googled and also did programming using SQLite and found that some BB devices dont support SQLite library and fail… >>> More
gwt+xml- can i read through incomplete XML using the GWT XML Parser

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a requirement where a user is typing in XML in a text area, and I want to show the various nodes in a tree...But as the user is typing in the xml, it wont be a complete xml (since he is still typing in the XML)... How do I read an incomplete XML and correctly generate the tree? I understand… >>> More
perl xml parser get xml content within xml

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use XMLParser to get the item-@url, item-@replace and item-"value inside" for the content as a string of the node where item-@cone="one"? <cstep> <item cone="one" url="http://google.com/{ccc}/cthree" replace="{ccc}"> <itemsub conesub="conesub"> … >>> More
Reading php generated XML in flash?

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is part 1 of our problem (Loading a dynamically generated XML file as PHP in Flash). Now we were able to get Flash to read the XML file, but we can only see the Flash render correctly when tested(test movie) from the actual Flash program. However, when we upload our files online to preview the… >>> More
Announcing RSS feeds of Microsoft All-In-One Code Framework code samples

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Today, we are not only announcing Sample Browser v2 CTP, but we are also excited to announce the availability of RSS feeds of All-In-One Code Framework code samples. By using these feeds, you can easily track and download the new code samples. English RSS feeds All code samples: http://support… >>> More

Related posts about xsl

Optimisation <xsl:apply-templates/> for a set of tags.

as seen on Stack Overflow - Search for 'Stack Overflow'
How it is possible to reduce this record? <xsl:template match="BR"> <br/> </xsl:template> <xsl:template match="B"> <strong><xsl:apply-templates /></strong> </xsl:template> <xsl:template match="STRONG"> <strong><xsl:apply-templates… >>> More
How do I set the encoding statement in the XML declaration when performing an XSL transformation usi

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a simple package installer in WinBatch that needs to update an XML file with information about the package contents. My first stab at it involved loading the file with Msxml2.DOMDocument, adding nodes and data as required, then saving the data back to disk. This worked well enough, except… >>> More
Using xsl:variable in a xsl:foreach select statment

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to iterate through an xml document using xsl:foreach but I need the select=" " to be dynamic so I'm using a variable as the source. Here's what I've tried: ... <xsl:template name="SetDataPath"> <xsl:param name="Type" /> <xsl:variable name="Path_1">/Rating/Path1/*</xsl:variable> … >>> More
xsl literal with <xsl:if>

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to write a very simple code in xsl: IF column=0 if result = .34 set background color to green and write $result, but if result = 0.10 set background color to white and write the word "QQQ" and what doesn't work is: <xsl:if test="$result = 0.35 and $column = 0"> <xsl:attribute… >>> More
XSL testing empty strings with <xsl:if> and sorting

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble with a template that has to check 3 different nodes and if they are not empty, print the data I am using for each node then doing the output but it is not printing anything. It is like the test returns zero. I have selected the parent node of each node i want to check the length… >>> More