Parsing A List In A Webpage Help - Need Webpage Parsing Help

NotoriousZach

Mar 20 2005, 11:52 PM

Hey I want to parse a list in a webpage.......Im not too hot with parsing overall but I figured this would be the best place to ask for help.....

For example

if the HTML was

CODE

<tr>
<td>1</td><td><A target="_self" href=#>Number1</a><td>IDNUMBER1</td>

<td><A target="_self" href=#>Number2</a><td>61506</td><td>ID NUMER2</td>

If i wanted to parse that into a list box where it showed
Number ID
---------------
Number1 IDNUMBER1
Number2 IDNUMBER2

Hopefully you guys can make some sense of that....

CODE

note by serverph to NotoriousZach: code-tagged as needed. pls comply next time. :)

Galahad

Mar 21 2005, 10:06 PM

Ok, from what I see without testing the code, I see you have 6 cells, in one row (I assume you accidentaly ommited </td> closing tags)... Now, since the columns you want, are defined in a same way, here is a sample code, that should work (I'll test it, and post back a VB code, if you want)

CODE

Index = 0
Position = InStr(0,"<td>")
While Position > 0
Position = Position + Len("<td>")
ClosingTag = InStr(Position,"</td>")
Columns(Index) = Mid(HTML, Position, ClosingTag - Position)
Index = Index + 1
Position = InStr(Position,"<td>")
Wend

You then just need to go through the Columns array, and get the items you need, using some filter...

NOTE: I did not test this code, I wrote it straight from the head, but it should give you some idea what to do. Send me an email if you need further help

Hope this helped some

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE