How to get attribut value from xml element?

Question

I have the following xml which I take from specified url:

<gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">
    <gesmes:subject>...</gesmes:subject>
    <gesmes:Sender>...</gesmes:Sender>
    <Cube>
        <Cube time="2016-08-16">
           <Cube value="1" />
           <Cube value="2"/>
           <Cube value="3"/>
        </Cube>
    </Cube>
</gesmes:Envelope>

From this file I only need to take time value '2016-08-16' using Visual Basic code.

jdweng · Accepted Answer · 2016-08-17 09:32:25Z

1

Try xml linq

Imports System.Xml
Imports System.Xml.Linq
Module Module1
    Const FILENAME As String = "c:\temp\test.xml"
    Sub Main()
        Dim doc As XDocument = XDocument.Load(FILENAME)
        Dim _date As DateTime = CType(doc.Descendants().Where(Function(x) (x.Name.LocalName = "Cube") And (Not x.Attribute("time") Is Nothing)).Select(Function(x) x.Attribute("time")).FirstOrDefault(), DateTime)
    End Sub

End Module

answered Aug 17, 2016 at 9:32

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

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

Comments

FloatingKiwi · Accepted Answer · 2016-08-17 09:18:36Z

1

Add these imports:

Imports <xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01">
Imports <xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">

Then load your data however you wish into an XDocument or XElement

Dim xmlDoc = XDocument.Load("myxml.xml")

The query it as follows. (if you're using XElement don't include Root).

Dim time = xmlDoc.Root.<Cube>.<Cube>.@time

edited Aug 17, 2016 at 9:18

answered Aug 17, 2016 at 9:14

FloatingKiwi

4,5161 gold badge20 silver badges46 bronze badges

2 Comments

Sehnsucht Over a year ago

If you use an XDocument you need to access the Root property first (and I'm not sure the Load will work without an xml declaration on the sample). OTOH you can use an XElement instead

FloatingKiwi Over a year ago

Thanks @Sehnsucht I've added the missing Root. I developed it using XElement and then got caught out with the shortcut.

Collectives™ on Stack Overflow

How to get attribut value from xml element?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related