Anthony,

I know that and really appreciate it. But sometimes it is not so
motivate to ask question in this forum, really want to learn this
language and I am doing it by my own, I do not know anyone who can
helps me :(

The xml input was not mine (it was a sample from the original) and the
output it is made to fit in ms access that apparently accepts only
elements and not attributes.

thanks

Ina


Anthony Jones wrote:
> "ina" <roberta.inalbon@g...> wrote in message
> news:1152773675.498037.59280@3......
> > Thank you Antony for your time and answer. Really appreciate.
> > But I am sorry to be newbie in XML and ask, as you pretend, "stupid
> > question" because I am learning XML/XSLT.
> >
> > Really, I do not understand why in this group people are so arogant!
> >
>
> Well let me explain it to you. Most people in this group who have the
> answers do so in their spare time which often is limited.  We want to help
> but many of us don't have the time to both answer the technical question and
> also sugar coat the facts just in case others might take offence.  So there
> is a tendancy to just state the facts.  It's an unfortunate nature of text
> based comminication that this can seem cold.  There is no intent to make a
> person feel bad, just a desire to provide the raw help without the social
> frills.
>
> Basically NGs in general are not places to be if you have a thin skin and
> you need to recognise that the tone in which you read message is not
> necessarily the one it was written in.
>
> > Ina
> >
> >
> > Anthony Jones wrote:
> > > "ina" <roberta.inalbon@g...> wrote in message
> > > news:1152277641.303201.170200@m......
> > > > Hello,
> > > >
> > > > I have a xml file with this structure
> > > >
> > > > <root>
> > > > <rooms>
> > > > <roomsA price="56"/>
> > > > <date>26/02/2006</date>
> > > > <roomsA>
> > > > <roomA price="65"/>
> > > > <date>26/03/2006</date>
> > > > </roomsA>
> > > >
> > > > <roomB price="59">
> > > > <date>26/02/2006</date>
> > > > </roomB>
> > > > <roomB price="75">
> > > > <date>26/03/2006</date>
> > > > </roomB>
> > > > <roomC price="45">
> > > > <date>26/02/2006</date>
> > > > </roomC>
> > > > <roomC price="75">
> > > > <date>26/03/2006</date>
> > > > </roomC>
> > > > </rooms>
> > > > </root>
> > > >
> > > >
> > > > and I would like to obtain something like this
> > > >
> > > > <Room>
> > > > <date>26/02/2006</date>
> > > > <roomsAprice>56</roomsAprice>
> > > > <roomsBprice>59</roomsBprice>
> > > > <roomsCprice>45</roomsCprice>
> > > > </Room>
> > > > <Room>
> > > > <roomsAprice>65</roomsAprice>
> > > > <roomsBprice>75</roomsBprice>
> > > > <roomsCprice>75</roomsCprice>
> > > > <Date>26/03/2006</Date>
> > > > </Room>
> > > >
> > > >
> > >
> > > I'm afraid the XML you are starting off with is poor quality but your
> > > proposed output is even worse.
> > >
> > > The fact your initial example is inconsistent it's makes it  difficult
> to
> > > see what help you really need.
> > >
> > > Might I suggest the clean output XML that is required is:-
> > >
> > > <root>
> > >  <room date="26 Feb 2006">
> > >     <price type="A">56</price>
> > >     <price type="B">59</price>
> > >     <price type="C">45</price>
> > >  </room>
> > >  <room date="26 Mar 2006">
> > >     <price type="A">65</price>
> > >     <price type="B">75</price>
> > >     <price type="C">75</price>
> > >  </room>
> > > </root>
> > >
> > > It's not easy sorting out the date format choice that would be better
> > > changed at source however the restructuring would look like this:-
> > >
> > > <?xml version="1.0" encoding="utf-8" ?>
> > > <xsl:stylesheet version="1.0"
> > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> > >  <xsl:output method="xml" indent="yes" />
> > >  <xsl:key name="dates" match="date" use="." />
> > >
> > >     <xsl:template match="/root/rooms">
> > >   <root>
> > >    <xsl:for-each select="*[count(key('dates',date)[1] | ./date) = 1]">
> > >     <room date="{date}">
> > >      <xsl:for-each select="key('dates', date)/parent::*">
> > >       <price band="{substring-after(local-name(),'room')}">
> > >        <xsl:value-of select="@price" />
> > >       </price>
> > >      </xsl:for-each>
> > >     </room>
> > >    </xsl:for-each>
> > >   </root>
> > >     </xsl:template>
> > >
> > > </xsl:stylesheet>
> > >
> > > This assumes that your input really looks like this:-
> > >
> > > <root>
> > >  <rooms>
> > >   <roomA price="56">
> > >    <date>26/02/2006</date>
> > >   </roomA>
> > >   <roomA price="65">
> > >    <date>26/03/2006</date>
> > >   </roomA>
> > >   <roomB price="59">
> > >    <date>26/02/2006</date>
> > >   </roomB>
> > >   <roomB price="75">
> > >    <date>26/03/2006</date>
> > >   </roomB>
> > >   <roomC price="45">
> > >    <date>26/02/2006</date>
> > >   </roomC>
> > >   <roomC price="75">
> > >    <date>26/03/2006</date>
> > >   </roomC>
> > >  </rooms>
> > > </root>
> > >
> > >
> > > Anthony.
> > >
> > >
> > >
> > > > I tried to do xsl:each-for and doesn't work very well.
> > > >
> > > > <?xml version='1.0' ?>
> > > > <xsl:stylesheet version="1.0"
> > > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> > > > <xsl:template match="/">
> > > > <xsl:for-each select="root/rooms">
> > > > <Root>
> > > > <xsl:for-each select="roomC">
> > > > <xsl:for-each select="../roomB">
> > > > <xsl:for-each select="../roomA">
> > > > <rooms>
> > > > <roomsAprice>
> > > > <xsl:value-of select="."/>
> > > > </roomsAprice>
> > > > <roomsBprice>
> > > > <xsl:value-of select="../roomB"/>
> > > > </roomsBprice>
> > > > <roomsCprice>
> > > > <xsl:value-of select="../roomC"/>
> > > > </roomsCprice>
> > > > <Date>
> > > > <xsl:value-of select="@date"/>
> > > > </Date>
> > > > </rooms>
> > > > </xsl:for-each>
> > > > </xsl:for-each>
> > > > </xsl:for-each>
> > > > </Root>
> > > > </xsl:for-each>
> > > > </xsl:template>
> > > > </xsl:stylesheet>
> > > >
> > > > Can someone help me on that?
> > > >
> > > > Ina
> > > >
> >