I have the xml as follows:

<class name="2001">
   <student sex="F">Ann</student>
   <student sex="M">Bob</student>
   <student sex="F">Cindy</student>
   <student sex="F">Dianne</student>
   <student sex="M">Eric</student>
   ...
</class>
<class name="2002">
   <student sex="M">Frank</student>
   <student sex="F">Gina</student>
   ...
   ...
</class>

Now I want to use XSL to transform the xml to a csv file like:

Class,FemaleStudent,MaleStudent
2001,Ann,Bob,
,Cindy,Eric
,Dianne,,
...
2002,Gina,Frank,
...

So, the output will look like this in excel:

Class|Female|Male
------------------
2001
------------------
     |Ann   |Bob
------------------
     |Cindy |Eric
------------------
     |Dianne|
------------------
2002 |   |
------------------
     |Gina  |Frank
------------------
...

The hardest part is to sort the student nodes based on ************, but the student node come randomly, also I want to write the outuput to two columns.

Will that be easier if I sort the dom before applying the xsl?

Any help would be appreciated!



Kevin

__________________
Kevin

Any gurus out there? Or maybe this one is too hard?


Kevin

I assume you're having problems with the FMFMFM... sorting? Your problem reminds me of this topic http://p2p.wrox.com/topic.asp?TOPIC_ID=4714
does that solution help?