Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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