loop over similiar tags

JohnBampton · December 11th, 2009, 08:46 AM

Hello all,
Using XSLT 1.0
I have the following xml structure below. There must always be the first <DEWS tag, but the rest are optional. If there was a second dews tag it would be dews2 and so on. Now how do i loop over these tags in a for-each statement? Is this possible?

Code:

 <record>
        
        <DEWS1>DC22</DEWS1>
<DEWS2>DC23</DEWS1>
<DEWS3>DC24</DEWS1>
<DEWS4>DC25</DEWS1>
<DEWS5>DC26</DEWS1>
</record

Help would be much appreciated

Regards.

Martin Honnen · December 11th, 2009, 08:51 AM

Doesn't

Code:

<xsl:for-each select="/record/*">...</xsl:for-each>

suffice?
Or you could use

Code:

<xsl:for-each select="/record/*[starts-with(local-name(), 'DEWS')]">...</xsl:for-each>

if there are other child elements of 'record' you don't want to process.

JohnBampton · December 11th, 2009, 09:21 AM

Thanks Martin,

yeah there are other children so the second one is needed. I forgot about local-name.

Regards.

JohnBampton · December 11th, 2009, 09:54 AM

Hi, I am trying to get the first preceding value of CR for the type value
But it just seems to return the same value for both author records. Any ideas?

Code:

                        <xsl:for-each select="*[starts-with(local-name(), 'ICFN')]">
                            <author>
                                <name><xsl:value-of select="concat(.,', ',following-sibling::*[1])"/></name>
                                <type><xsl:value-of select="preceding-sibling::*[starts-with(local-name(),'CR')]"/></type>
                            </author>
                        </xsl:for-each>


<record>
<CR1>asdfasdf</CR1>
        <CRT1>Edited by</CRT1>
        <CCI1>N</CCI1>
        <ICFN1>Adnan</ICFN1>
        <ICKN1>Ibrahimbegovic</ICKN1>
        <CR2>B01</CR2>
        <CRT2>Edited by</CRT2>
        <CCI2>N</CCI2>
        <ICFN2>Muhamed</ICFN2>
        <ICKN2>Zlatar</ICKN2>
</record>

Regards,

John.

samjudson · December 11th, 2009, 09:58 AM

preceding-sibling::*[starts-with(local-name(),'CR')][1]

And it probably doesn't help that the value is the SAME for both records.

Martin Honnen · December 11th, 2009, 09:58 AM

That snippet you posted has a 'CRT1' element and a 'CRT2' element, but both have the same contents 'Edited by' so I am not sure why you complain about getting the same value.

JohnBampton · December 11th, 2009, 10:13 AM

That was just a copy and paste error in the xml, normally they have different values. Thanks a lot

mhkay · December 11th, 2009, 10:38 AM

This is a horrible XML design. Do you have any control over it? There seems to be a sequence of XXX1 elements representing the first record, then a sequence of XXX2 elements representing the second record, and so on: so put each of these sequences inside a wrapper element, and use the same tags in each one.

If you can't get the design of the XML changed at source, it's worth transforming it into something more sanitory before you attempt any other kind of transformation. Then you only have to write the "sanitization" code once - everthing else will be able to start with clean input.

JohnBampton · December 11th, 2009, 10:52 AM

No i have no control over it. It is the Nielsen BookData Web Service: XML Format Field Specification
Regards.