Hi Cihan,
I'm trying to group timezone information into a table. The problem I
am having is the looping through the values of same time zone(ET),
same day(Monday), sorting(start with 12:00AM for AM, and start for
12:00PM for PM column) and filling them into two columns one of
which AM values only, and second PM values only.
Can you show us exactly what you want the result to look like for the
source XML you've given? What goes in the different rows of the
tables? Different programs? Different timezones?
I'm sure that what you want to do is doable. Possibly you need to do
some Muenchian grouping as described at
http://www.jenitennison.com/xslt/grouping/muenchian.html with a
compound key such as:
<xsl:key name="airings" match="airing"
use="concat(@day, parent::timezone/@value)" />
and you'll certainly need to use the substring() function to work out
which values are a.m. and which p.m., and to get the sorting to work,
but without knowing precisely what output you want it's hard to tell
you exactly what to do.
Cheers,
Jeni
---
Jeni Tennison
http://www.jenitennison.com/