Improve company productivity with a Business Account.Sign Up

x
?
Solved

Xpath 1.0 function for Exists

Posted on 2013-05-16
3
Medium Priority
?
443 Views
Last Modified: 2013-05-21
I have the following XML:

        <A>
          <B>
            <Amount>5000</Amount>
            <Start>60</Start>
            <End>65</End>
          </B>
          <B>
            <Amount>3000</Amount>
            <Start>63</Start>
          </B>
	  <B>
            <Amount>1234</Amount>
            <Start>61</Start>
            <End>67</End>
          </B>
        </A>

Open in new window


I want to create two Xpath queries that return me the 'start' and 'end' elements for each B.
Problem is, I now end up with two arrays of different lengths: (60;63;61) and (65;67).
I want to be able to detect which B doesn't have an end-element.

Therefore I should use a function like 'exists' or something like that, but I can only use the Xpath 1.0 library.
Anybody that can help me with this?
0
Comment
Question by:adiemeer
  • 2
3 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 39170796
//B[not(End)]
0
 

Author Comment

by:adiemeer
ID: 39170816
Thanks, this is helping me.
But how do I now construct the array of length 3? (With a dummy for the second element, f.i 65;999;67)
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 total points
ID: 39170825
you can't do that purely in XPath1.
XPath1 is for addressing a node(set)
The construction of the array happens outside XPath1.
That is where you need to add a dummy

I suggest that you make an array of B nodes and pull out either End or default from it in constructing a second array, whichever programming language you are using

boils down to ... " what programming language are you using?"

you could have a pass using XSLT that introduces a End element having value 999
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question