Subject: XSL to generate required output
From: "Amrit Pal Singh" <ampsingh@xxxxxxxxx>
Date: Mon, 12 Dec 2005 10:15:18 +0530
|
Hi friends,
I'm Having following input xml file.
<?xml version="1.0" encoding="UTF-8"?>
<WoorkBook>
<WorkSheet>
<Name>Tarifs Clts & prog. de commande</Name>
<table>
<Row>
<Cell>##</Cell>
</Row>
<Row>
<Cell>COUPE</Cell>
<Cell>Puissance</Cell>
<Cell>Transmission</Cell>
<Cell>Puissance fiscale</Cell>
<Cell>Prix clientTTC EUR </Cell>
<Cell>Code modhle</Cell>
</Row>
<Row/>
<Row>
<Cell>Audi TT</Cell>
<Cell>163 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>10 CV*</Cell>
<Cell>28900</Cell>
<Cell>8N30L40C00</Cell>
</Row>
<Row>
<Cell>Audi TT</Cell>
<Cell>190 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>12 CV*</Cell>
<Cell>30800</Cell>
<Cell>8N30M40C00</Cell>
</Row>
<Row>
<Cell>##</Cell>
</Row>
<Row/>
<Row>
<Cell>Audi TT</Cell>
<Cell>163 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>10 CV*</Cell>
<Cell>31000</Cell>
<Cell>8N90L40C00</Cell>
</Row>
<Row>
<Cell>Audi TT</Cell>
<Cell>190 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>12 CV*</Cell>
<Cell>33300</Cell>
<Cell>8N90M40C00</Cell>
</Row>
</table>
</WorkSheet>
</WoorkBook>
I need to generate the ouput as below. i.e to take hierarchy one level down
when I see ## in Cell.
<?xml version="1.0" encoding="UTF-8"?>
<WoorkBook>
<WorkSheet>
<Name>Tarifs Clts & prog. de commande</Name>
<table>
<New>
<Row>
<Cell>COUPE</Cell>
<Cell>Puissance</Cell>
<Cell>Transmission</Cell>
<Cell>Puissance fiscale</Cell>
<Cell>Prix clientTTC EUR </Cell>
<Cell>Code modhle</Cell>
</Row>
<Row/>
<Row>
<Cell>Audi TT</Cell>
<Cell>163 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>10 CV*</Cell>
<Cell>28900</Cell>
<Cell>8N30L40C00</Cell>
</Row>
<Row>
<Cell>Audi TT</Cell>
<Cell>190 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>12 CV*</Cell>
<Cell>30800</Cell>
<Cell>8N30M40C00</Cell>
</Row>
</New>
<New>
<Row>
<Cell>Audi TT</Cell>
<Cell>163 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>10 CV*</Cell>
<Cell>31000</Cell>
<Cell>8N90L40C00</Cell>
</Row>
<Row>
<Cell>Audi TT</Cell>
<Cell>190 ch</Cell>
<Cell>BV 5 </Cell>
<Cell>12 CV*</Cell>
<Cell>33300</Cell>
<Cell>8N90M40C00</Cell>
</Row>
</New>
</table>
</WorkSheet>
</WoorkBook>
Please let me know how to achaive this.
Thanks,
Amrit
|