Help in making a FLAT xml to a structured xml

shlomi · July 19th, 2007, 07:58 AM

Hello,

I have a problem I didnt manage to solve, and I really need some help in:

I have a flat xml for properties:

Code:

<ROOT>
 <Prop Name="a.b.c" Val="1"/>
 <Prop Name="a.b.d" Val="2"/>
 <Prop Name="a.a.a" Val="3"/>
</ROOT>

I want to transform this into something like:

Code:

<ROOT>
 <PropGroup Name="a">

   <PropGroup Name="b">
    <Prop Name="c" Val="1"/>
    <Prop Name="d" Val="2"/>
   </PropGroup>

   <PropGroup Name="a">
    <Prop Name="a" Val="3"/>
   </PropGroup>

 </PropGroup>
</ROOT>

Any help is appreciated,
Thanks,
Shlomi