[RESOLVED] parsing an html file

Printable View

Jun 10th, 2006, 02:44 PM
litlewiki

[RESOLVED] parsing an html file
iam working on a small applic that extracts the last person who has scrapped in my scrapbook

the saved html page should explain everything abt scraps and scrapbook etc
i also attached a sample screenshot with the required link circled in the screenshot...

i tried the following but din work:
VB Code:
```
Dim PosEnd As Long
        Dim PosStart As Long
        PosStart = InStr(WebBrowser1.Document.body.innerHTML, "<a class="P" href="/Profile.aspx?uid=")
    ....
```
this will not work as the match string contains quotes

and one more thing to note that here i have scrapped myself hence the uid=....(19 digit number) is the same everywhere which does not happen in a normal scenario.

i have an inetcontrol that is loading the page .i am using
VB Code:
```
WebBrowser1.Document.getElementsByTagName("b").Item(i + 2).innerText....
```
to parse other elemnts but this one seems to be too complex

any ideas anyone??
Jun 10th, 2006, 02:53 PM
bushmobile

Re: parsing an html file
to answer your first question:

where you want to place " in a string, use "", e.g.:
VB Code:
```
Debug.Print "<a class=""P"" href=""/Profile.aspx?uid="
```
would give you:

Code:

<a class="P" href="/Profile.aspx?uid=
Jun 10th, 2006, 02:57 PM
smUX

Re: parsing an html file

First question...the line where you have " in the code...one which starts with "PosStart"...where you see a ", you need to put " & chr(34) & " (note the quote at the start and end...this closes the string so you can do variable functions, then reopens it for new text

so change:

"<a class="P" href="/Profile.aspx?uid="

into

"<a class=" & chr(34) & "P" & chr(34) & " href=" & chr(34) & "/Profile.aspx?uid="

Edit: I assume bush's way will work too...if not, mine definitely does :-)