Access attribute value xpath

Question

I am trying to access the longitude value (-1.914) from this xml snippet where itemfileUID = 2000044 using an xpath query in vba [via Set latitudes = oXMLFile.SelectNodes("//ViewCoordinates[itemFileUID = '2000044']/ViewCoordinatePair[@name = 'latitude']/@value").] Can anyone help?

I have searched and searched but not found a way to find an attribute value based upon the contents of an element in the same node.

Thanks Tom

<schema>
    <view>
        <ViewCoordinatesList>
            <ViewCoordinates>
                <itemFileUID>2000044</ItemFileUID>
                <ViewCoordinatePair name="longitude" value="-1.91496237"/>
                <ViewCoordinatePair name="latitude" value="53.70811065"/>
                <ViewCoordinatePair name="height" value="136.06"/>
                <ViewCoordinatePair name="yaw" value="168.083809"/>
            </ViewCoordinates>
        </ViewCoordinatesList>
    </view>
</schema>

Note that you are asking latitude, but mentioning -1.914 which is longitude in your sample. — alecxe
– alecxe, Commented Aug 4, 2016 at 16:00

alecxe · Accepted Answer · 2016-08-04 15:58:44Z

2

Use the following-sibling axis:

//itemFileUID[. = '2000044']/following-sibling::ViewCoordinatePair[@name = 'longitude']/@value

Or, checking the parent:

//ViewCoordinates[itemFileUID = '2000044']/ViewCoordinatePair[@name = 'longitude']/@value

answered Aug 4, 2016 at 15:58

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

4 Comments

TomH Over a year ago

thanks for this - I am trying to msgbox this value but failing?

alecxe Over a year ago

@TomH okay, failing how? Where are you running this in? Thanks.

TomH Over a year ago

@alexce - vba - this returns a IXMLDOMSelection and I don't know how to access the string... this isn't my field as you can guess...

alecxe Over a year ago

@TomH not familiar with xml parsing with VBA unfortnately, but I suspect you should match the nodes first omitting the /@value part at the end. Then, when you have a node, get the value of value attribute/property.

TomH · Accepted Answer · 2016-08-05 08:09:18Z

0

This was the solution:

Set latitude = oXMLFile.SelectNodes("/schema/View/ViewCoordinatesList/ViewCoordinates[ItemFileUID = '2000044']/ViewCoordinatePair[@name = 'longitude']")
MsgBox latitude(0).getAttribute("value")

Thanks for people's help

answered Aug 5, 2016 at 8:09

TomH

1016 bronze badges

Collectives™ on Stack Overflow

Access attribute value xpath

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related