XPath To Siblings

ritagr · July 26th, 2012, 03:02 PM

Hello.

Here's an example of my XML file.

Code:

<doc>
 <EOB>
  <DETAIL>
   <DETAILLINE>
    <RCDATA>
     <RCDATALINE>
      <RC>01</RC>
     </RCDATALINE
     <RCDATALINE>
      <RC>02</RC>
     </RCDATALINE
    </RCDATA>
    <CRCDATA>
     <CRCDATALINE>
      <CRC>AA</CRC>
     </CRCDATALINE>
     <CRCDATALINE>
      <CRC>AB</CRC>
     </CRCDATALINE>
    </CRCDATA>
   </DETAILLINE>
   <DETAILLINE>
    <RCDATA>
     <RCDATALINE>
      <RC>03</RC>
     </RCDATALINE
     <RCDATALINE>
      <RC>04</RC>
     </RCDATALINE
    </RCDATA>
    <CRCDATA>
     <CRCDATALINE>
      <CRC>AC</CRC>
     </CRCDATALINE>
     <CRCDATALINE>
      <CRC>AD</CRC>
     </CRCDATALINE>
    </CRCDATA>
   </DETAILLINE>
  </DETAIL  
 </EOB>
</doc>

What I need to accomplish is this:
I have a for-each loop on the <DETAILLINE>.
Within this loop I have another for-each loop on the <RCDATALINE>.
In this second loop if <RC> is not empty then I need to check <CRCDATALINE><CRC> that it's not empty.

I've tried using following-sibling without any success.
Here's my partial code.

Code:

<xsl:for-each select="DETAILLINE">
 <xsl:for-each select="RCDATA/RCDATALINE">
    <xsl:if test="RC[.!='']>
      <xsl:if test="(following-sibling::*/CRCDATA/CRCDATALINE/CRC[.!='']>

This does not work because following-sibling probably applies to <RCDATALINE> and I need it to apply to be the following-sibling of <RCDATA>.

Any help will be greatly appreciated!

Thanks,
Rita

ritagr · July 26th, 2012, 04:00 PM

I finally got it to work using this code:
<xsl:if test="(../../CRCDATA/CRCDATALINE/CRC[.!=''])">