[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] XSL Positional Grouping Problem

---

---

Hello, I'm hoping that someone can point me in the right direction.  I
have the following need:

I have been sent an MS Excel file that I have been asked to transform
in the following way...

<Table>
 <Row>
   <Cell><Data>Level 1</Data></Cell>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
  </Row>
<Row>
   <Cell/>
   <Cell><Data>Level 2</Data></Cell>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
   <Cell/>
  </Row>

..+5000 Rows

</Table

To a nested structure which is based on the position of the <Data> tag.

<Table>
 <Level><Data>Level 1</Data>
     <Level><Data>Level 2</Data</Level>

..etc

 </Level>
</Table>

The nesting goes both up and down levels so I'm assuming recusion is
the way to go but the level of existing nesting has me wracking my
brains (when you don't do much of this it is a daunting task...). Thanks in advance,

Luke.

---