Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

vb.net application parse through html file and find values

ok, I have a vb.net forms application, this application has to read values from an html file on the hard drive.

What I want to do is write a function that can pull all the values I need from the html file into my program, here is an example of two of the values I need to pull out.

The good thing is that each value is embedded in a span tag and has it's own unique id attribute.

I need someone to guide me through parsing the dom to get the element values by id.

Here is two examples:

How would I write my code to pull the values Blue, and Busy from my html file.

<span id="lblColor">Blue</span>
<span id="lblStatus">Busy</span>

thanks in advance.
0
talker2004
Asked:
talker2004
  • 2
1 Solution
 
nmarunCommented:
Here's the code for the html file reader. Just tweak to check if the .Name property is 'span' and in the attributes section, check for 'lblColor' and 'lblStatus' attributes.

listBox1.Items.Clear()
Dim i As Integer = 0
Dim xtr As New XmlTextReader("c:\test.html")
xtr.WhitespaceHandling = WhitespaceHandling.None
 
While xtr.Read()
    Dim s As String = (((i.ToString() & "-") + xtr.NodeType & " ") + xtr.Name & " ") + xtr.Value.ToString() & " "
    
    If xtr.HasAttributes Then
        For j As Integer = 0 To xtr.AttributeCount - 1
            xtr.MoveToAttribute(j)
            s += (" ATT:" & xtr.Name & " =") + xtr.GetAttribute(j)
        Next
    End If
    listBox1.Items.Add(s)
    i += 1
End While

Open in new window

0
 
nmarunCommented:
The above code adds formatted values to a listbox, you might want to remove that piece of code.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now