Parse specific XML in VB.NET

Question

0.00/5 (No votes)

See more:

Hi,

I dont code that often, and i forget. So instead of hours of googling for something i dont know what is called, i ask a question here with the experts :)

I want to get specific values out of this XML:

<?xml version="1.0" encoding="UTF-16" ?>
<ROOT>
   <TREE Version="01.00" Company="OTHER" StationNr="0111">
      <Device Type="1">
         <Property Type="1">111</Property>
         <Device Type="2" Number="1">
            <Property Type="34">INT</Property>
            <Device Type="3">
               <Device Type="4" Number="1">
                  <Property Type="56">192.168.242.192</Property>
                  <Device Type="29">
                     <Property Type="71">11016938</Property>
				  </Device>
               </Device>
               <Device Type="4" Number="2">
                  <Property Type="56">192.168.242.193</Property>
                  <Device Type="29">
                     <Property Type="71">11016933</Property>
                  </Device>
               </Device>
            </Device>
         </Device>
      </Device>
   </TREE>
</ROOT>

Heres what i am looking for:
I want to look for the property attribute 56 and get the value of 192.168.242.192 when reading.
I also want to loop through property type 2, to find all device type 4.
I also would like to get the value Property Type="71" of this one.

I have a few examples from my past coding, but no XML i have used in the past, looks like this one.

Any idea what to search for?

Kind regards
Kenneth

What I have tried:

I have tried using some old code snipplets and googleing for something i cannot find

Posted 8-Apr-20 14:01pm

kjohansen2000

Updated 8-Apr-20 22:03pm

Add a Solution

Comments

Maciej Los 9-Apr-20 3:49am

I do not see "property type 2" in an xml you've posted.
The description of what you want to achieve is not clear. Please, be more specific and provide sample output.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2020-04-08T22:04:00

Solution 1

Take a look at below example:

VB.NET

Dim xdoc As XDocument = XDocument.Load("FullFileName.xml")
Dim deviceTypes2find As String() = {"1", "4"}
Dim propTypes2find As String() = {"56", "71"}

Dim result = xdoc.Descendants("Property"). _
    Where(Function(x) propTypes2find.Any(Function(a) x.Attribute("Type").Value=a) AndAlso _
        deviceTypes2find.Any(Function(y) x.Parent.Attribute("Type").Value = y)). _
    Select(Function(x) Tuple.Create(x.Parent.Attribute("Type").Value, x.Attribute("Type").Value, x.Value)). _
    ToList()
Console.WriteLine(String.Format("{0}{1}{2}{1}{3}", "DeviceTypeId", Microsoft.VisualBasic.vbTab, "PropertyTypeId", "Value"))
For Each t As Tuple(Of String, String, String) In result
    Console.WriteLine(String.Format("{0}{1}{2}{1}{3}", t.Item1, Microsoft.VisualBasic.vbTab, t.Item2, t.Item3))
Next

Result:

DeviceTypeId PropertyTypeId  Value
4            56              192.168.242.192
4            56              192.168.242.193

Posted 8-Apr-20 22:04pm

Maciej Los

Updated 9-Apr-20 1:37am

v3

Comments

kjohansen2000 9-Apr-20 4:36am

Thank you very much, this takes me a very good part of the road and learned me something new!

The files i need to read are actually close to 10.000 rows and a lot of duplicated "type" numbers.
Can you give me a hint to read the file in a hierarchical way?

When reading the file as a human, i see that Device type 1 has a device type 2, and that has a device type 3, that has 2x device type 4. Those Device type 4, has their own type 56, but 56 is also a value in type 1, so i would like to see if the type 56 i read belongs to a type 4 or a type 1, does it make sense?

Sorry for not posting the full file.

Maciej Los 9-Apr-20 4:38am

Does other devices have nodes with Property types of 56 and 71?
In the example you provided, devices with types of 1,2,3 have no nodes with Property types of 56 and 71...

kjohansen2000 9-Apr-20 4:46am

Correct, i tried to limit the file to the needed, but maybe it just made it harder for me getting help.

Yes, other devices also has 56 and 71's

Maciej Los 9-Apr-20 5:19am

See updated answer (again).

kjohansen2000 9-Apr-20 12:38pm

I owe you a large cold beer in the sun.. THANKS !!!

Maciej Los 9-Apr-20 12:56pm

Well...
Denmark beer is very good, so i will take an advantage of meeting for a beer in the sun. I'll take Polish beer to give you a chance to taste it. But(!) we will have to wait till chance of being infected by the COVID-19 will be very small.

Good luck!

kjohansen2000 20-Dec-21 18:07pm

Hi Maciej,

i still owe you that beer :)

One more question, if you are up to it?

<root>
<tree version="01.00" company="OTHER" stationnr="0111">
<device type="1">
<property type="1">111
<device type="2" number="1">
<property type="34">INT
<device type="3">
<device type="4" number="1">
<property type="56">192.168.242.192
<device type="29">
<property type="71">11016938

<device type="4" number="2">
<property type="56">192.168.242.193
<device type="29">
<property type="71">11016933

How do I extract the "Number" value in <device type="2" ...=""> ??

Kind regards
Kenneth

Maciej Los 29-Dec-21 12:47pm

Sorry, i was busy. You have to use the same logic...
This: x.Parent.Attribute("Type").Value extracts "Type" atribute. To get "Number" attribute, use: x.Parent.Attribute("Number").Value
:)