XPath expression with if condition statement

Question

I have an XML like the one below, but this is only a part of a bigger file.

example 1

<EFACT_D96A_INVOIC>
  <NADLoop1>
    <NAD NAD09="SE" NAD08="111 11" NAD07="" NAD06="CITY" NAD01="DP">
      <C082 C08203="9" C08202="" C08201="7350015610088"/>
      <C058 C05801="TESTNAME"/>
      <C080 C08001=""/>
      <C059 C05901="TESTSTREET 35"/>
    </NAD>
  </NADLoop1>
</EFACT_D96A_INVOIC>

example 2

<EFACT_D96A_INVOIC>
  <NADLoop1>
    <NAD NAD09="SE" NAD08="111 11" NAD07="" NAD06="CITY" NAD01="DP">
      <C082 C08203="9" C08202="" C08201="7350015610088"/>
      <C058 C05801=""/>
      <C080 C08001="TESTNAME"/>
      <C059 C05901="TESTSTREET 35"/>
    </NAD>
  </NADLoop1>
</EFACT_D96A_INVOIC>

I want to make an XPath expression that returns the value of either the attribute C05801 if not empty or C08001. Is that possible to do with a oneline XPath?

Dmytro Pastovenskyi · Accepted Answer · 2015-10-23 08:15:11Z

1

What about this. You return both values (if they exists) and just take first one.

/EFACT_D96A_INVOIC/NADLoop1/NAD/*[@C05801!="" or @C08001!=""][1]

edited Oct 23, 2015 at 8:15

answered Oct 23, 2015 at 8:04

Dmytro Pastovenskyi

5,4496 gold badges42 silver badges58 bronze badges

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

5 Comments

Arto Uusikangas Over a year ago

I dont think you read my question correctly. I wanted to have either the value of C05801 or C08001 depending on which is filled out. The fact that the above XML sample has the C05801 filled out doesnt make your suggestion any helpful.

Dmytro Pastovenskyi Over a year ago

what version of xPath do you use 1 or 2?

Arto Uusikangas Over a year ago

I think it is xPath 1

Dmytro Pastovenskyi Over a year ago

What about solution when you return both values, and just take 1-st one? Would it suite you?

Arto Uusikangas Over a year ago

Nice! That really was a slick solution

Collectives™ on Stack Overflow

XPath expression with if condition statement

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related