Solved

Xpath 1.0 function for Exists

Posted on 2013-05-16
3
350 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 500 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now