Problem Getting to Nodes

ritagr · August 2nd, 2012, 01:58 PM

Hello.

I have the following XML file.

Code:

<doc>
    <EOB>
        <DETAIL>
            <DETAILLINE>
                <RCDATA>
                    <RCDATALINE>
                        <TRC>AAAAAAAAA1</TRC>
                    </RCDATALINE>
                    <RCDATALINE>
                        <TRC/>
                    </RCDATALINE>
                </RCDATA>
                <CRCDATA>
                    <CRCDATALINE>
                        <CRCFUNCTION>900</CRCFUNCTION>
                    </CRCDATALINE>
                    <CRCDATALINE>
                        <CRCFUNCTION/>
                    </CRCDATALINE>
                </CRCDATA>
            </DETAILLINE>
            <DETAILLINE>
                <RCDATA>
                    <RCDATALINE>
                        <TRC>WWWWWWWW1</TRC>
                    </RCDATALINE>
                    <RCDATALINE>
                        <TRC/>
                    </RCDATALINE>
                </RCDATA>
                <CRCDATA>
                    <CRCDATALINE>
                        <CRCFUNCTION>900</CRCFUNCTION>
                    </CRCDATALINE>
                    <CRCDATALINE>
                        <CRCFUNCTION/>
                    </CRCDATALINE>
                </CRCDATA>
            </DETAILLINE>
        </DETAIL>
    </EOB>
</doc>

I want to execute a template only if any occurrence of <TRC> has some text and any occurrence of <CRCFUNCTION> is not = '900'.

I tried the following code but the template is executed even though both the
<CRCFUNCTION> in both the <DETAILLINE> is '900'.

Code:

        <xsl:if test="/doc/EOB/DETAIL/DETAILLINE/RCDATA/RCDATALINE/TRC/descendant-or-self::*[.!=''] and /doc/EOB/DETAIL/DETAILLINE/CRCDATA/CRCDATALINE/CRCFUNCTION/descendant-or-self::*[.!='900']">

Any help will be greatly appreciated!

Thanks,
Rita

ritagr · August 2nd, 2012, 04:54 PM

Well, I finally figured out my problem. Using "<xsl:if test="/doc/EOB/DETAIL/DETAILLINE/CRCDATA/CRCDATALINE/CRCFUNCTION!='900"> didn't work because there was a CRCFUNCTION that was = '' which satisfied the if condition.

So now I need to determine if the CRCFUNCTION is not = '900' and not = ''.
Can somebody help me with that? I tried using position() but could not get it to work.

Thanks!

mhkay · August 3rd, 2012, 12:01 PM

Generally, steer well clear of the "!=" operator when the operands are possibly empty or possibly multiple values. Use not(A = B) instead. So here you want not(. = ('900', ''))

ritagr · August 3rd, 2012, 12:46 PM

Wow! Thank you so much.
I knew there has to be a simple answer :-)