Get non empty element in XML using XPath expression including

Question

I have the following and want to retrieve data where the 'FromEmail' is not empty

<FILE NAME="NewbusQuote">
   <REC NAME="level1">
        <FLD NAME="CoverPage"></FLD>
        <FLD NAME="FromEmail"></FLD>
       </REC>

    <REC NAME="leve2">
        <FLD NAME="CoverPage">Simple</FLD>
        <FLD NAME="FromEmail">[email protected]</FLD>
    </REC>


    <REC NAME="leve3">
        <FLD NAME="CoverPage"></FLD>
        <FLD NAME="FromEmail"></FLD>
    </REC>
</FILE>

Thank you in advance

@ Wrikken, I shall try that I just don't know how to go around it when names come to play.@ lwburk, sorry I forgot to mention proper, the non empty FromEmail is the one I want. — Raymond Nakampe
– Raymond Nakampe, Commented Jan 30, 2014 at 22:46

Allwe · Accepted Answer · 2014-01-31 00:22:26Z

2

This XPath

/FILE/REC/FLD[@NAME = 'FromEmail']

will return FLD elements with attribute FromEmail, but this query

/FILE/REC/FLD[@NAME = 'FromEmail']/text()

will return only text content of second FromEmail element.

XPath in general doesn't retrieve empty elements (it's the same like if they were <FLD NAME="FromEmail" />).

to get all data from all elements with FromEmail atributte, use this

/FILE/REC//FLD[@NAME = 'FromEmail']/text()

Hope it helps

edited Jan 31, 2014 at 0:22

answered Jan 31, 2014 at 0:10

Allwe

4811 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get non empty element in XML using XPath expression including

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related