[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Grouping problem
Hi, How would I group following information based on time-zone and the day? There are 40 prog elements, and the desired output should look like the following table, and an excerpt of XML file is also part of this e-mail. Thanks, Time Zone (timezone[@value] Airing Day (airing[@day]) (Values are 1 to 7, starting with Monday) Time (time[@value]) = Title (prog[@title]) Example for the Eastern Time for Monday and Tuesday. _________________ ET Monday 1:00 am : Asthma 6:30 am : Cancer 9:00 am : Asthma 2:30 pm : Cancer 5:00 pm : Asthma 10:30 pm : Cancer Tuesday 6:30 am : Cancer 2:30 pm : Cancer 10:30 pm : Cancer --------------------------------- ---------------XML file------- <main_schedule> <schedule> <prog ID="1" title="Asthma"> <description><![CDATA[Asthma is a serious, allergy-related breathing difficulty]]></description> <timezone value="ET"> <airing day="1"> <time value="1:00am"/> <time value="9:00am"/> <time value="5:00pm"/> </airing> <airing day="2"/> <airing day="3"/> <airing day="4"> <time value="1:00am"/> <time value="9:00am"/> <time value="5:00pm"/> </airing> <airing day="5"/> <airing day="6"/> <airing day="7"/> </timezone> <timezone value="CT"> <airing day="1"> <time value="12:00am"/> <time value="8:00am"/> <time value="4:00pm"/> </airing> <airing day="2"/> <airing day="3"/> <airing day="4"> <time value="12:00am"/> <time value="8:00am"/> <time value="4:00pm"/> </airing> <airing day="5"/> <airing day="6"/> <airing day="7"/> </timezone> <timezone value="MT"> <airing day="1"> <time value="7:00am"/> <time value="3:00pm"/> </airing> <airing day="2"/> <airing day="3"> <time value="11:00pm"/> </airing> <airing day="4"> <time value="7:00am"/> <time value="3:00pm"/> </airing> <airing day="5"/> <airing day="6"/> <airing day="7"> <time value="11:00pm"/> </airing> </timezone> </prog> <prog ID="2" title="Cancer"> <description><![CDATA[Cancer is...]]></description> <timezone value="ET"> <airing day="1"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="2"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="3"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="4"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="5"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="6"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> <airing day="7"> <time value="6:30am"/> <time value="2:30pm"/> <time value="10:30pm"/> </airing> </timezone> <timezone value="CT"> <airing day="1"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="2"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="3"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="4"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="5"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="6"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> <airing day="7"> <time value="5:30am"/> <time value="1:30pm"/> <time value="9:30pm"/> </airing> </timezone> <timezone value="MT"> <airing day="1"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="2"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="3"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="4"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="5"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="6"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> <airing day="7"> <time value="4:30am"/> <time value="12:30pm"/> <time value="8:30pm"/> </airing> </timezone> </prog> </schedule> </main_schedule> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|