I have an very special request, in the following sample xml, data03 is sales data for Dec 2008, data04 is sales data for Jan 2009.

The request is filter out weekend data. As you can see, I can't just filter out record by record. Since day="01" is Monday in Dec 2008, Tuesday in Jan 2009, and Sunday in Feb 2009.

I am using XSLT 1.0, any idea are highly appreciated!

<?xml version="1.0"?>
<result>
<chartheader header03=" Dec 2008" header04=" Jan 2009" header05=" Feb 2009"/>
<chartdata>
<row day="01" data03="10" data04="10" data05="10"/>
<row day="02" data03="11" data04="11" data05="11"/>
<row day="03" data03="12" data04="12" data05="12"/>
<row day="04" data03="13" data04="13" data05="13"/>
<row day="05" data03="14" data04="14" data05="14"/>
<row day="06" data03="15" data04="15" data05="15"/>
<row day="07" data03="16" data04="16" data05="16"/>
<row day="08" data03="17" data04="17" data05="17"/>
<row day="09" data03="18" data04="18" data05="18"/>
<row day="10" data03="19" data04="19" data05="19"/>
<row day="11" data03="20" data04="20" data05="20"/>
<row day="12" data03="21" data04="21" data05="21"/>
<row day="13" data03="22" data04="22" data05="22"/>
<row day="14" data03="23" data04="23" data05="23"/>
<row day="15" data03="24" data04="24" data05="24"/>
<row day="16" data03="25" data04="25" data05="25"/>
<row day="17" data03="26" data04="26" data05="26"/>
<row day="18" data03="27" data04="27" data05="27"/>
<row day="19" data03="28" data04="28" data05="28"/>
<row day="20" data03="29" data04="29" data05="29"/>
<row day="21" data03="30" data04="30" data05="30"/>
<row day="22" data03="31" data04="31" data05="31"/>
<row day="23" data03="32" data04="32" data05="32"/>
<row day="24" data03="33" data04="33" data05="33"/>
<row day="25" data03="34" data04="34" data05="34"/>
<row day="26" data03="35" data04="35" data05="35"/>
<row day="27" data03="36" data04="36" data05="36"/>
<row day="28" data03="37" data04="37" data05="37"/>
<row day="29" data03="38" data04="38" data05=""/>
<row day="30" data03="39" data04="39" data05=""/>
<row day="31" data03="40" data04="40" data05=""/>
</chartdata>
</result>

Thanks a lot!

__________________
George Meng

If you are using XSLT 2.0, first construct an xs:date value (YYYY-MM-DD) by string-manipulation, then use format-date($date, '[F1]', (), 'ISO', ()) to get the day of the week (1=Monday, 7=Sunday).

With XSLT 1.0, you could look at the EXSLT date and time handling library.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference