if xpath result is empty return "empty" string

Question

how to make xpath 1.0 behave like if value is empty - return string "empty"

if I have an XML

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<query systemEnvironmentCode="UAT">
    <trxid>107</trxid>
    <ladid/>
</query>

In case when ladid is empty I want it to return "empty" string, if it's not empty - return ladid's value

score 1 · Accepted Answer · edited May 23 '17 at 10:25

1

In case you want to have the string empty instead of an empty sting as a result for empty elements the following XPath should do it:

concat(
    substring(string(/query/ladid), 1,
        number(string(/query/ladid) != '') * string-length(/query/ladid)),
    substring('empty', 1,
        number(string(/query/ladid) = '') * 5)
)

It is based on https://stackoverflow.com/a/971665/948404.

edited May 23 '17 at 10:25

Community

1
1

answered Feb 05 '14 at 13:00

hielsnoppe

2,769
3
31
55

score 0 · Answer 2 · answered Feb 05 '14 at 12:38

0

Use the path string(/query/ladid).

answered Feb 05 '14 at 12:38

Martin Honnen

149,505
6
83
100

if xpath result is empty return "empty" string

2 Answers2