Extracting data from a string

[pankaj]

I've extract this from a webpage and stored in a string.

----------------------------------------------------------------------------
----------------------
<tr height="25">
<td nowrap class="odd" align="center"><img
src="/forums/images/icon_topic_new.gif" width=14 height=14 alt='New Topic'
border=0></td>

<td nowrap class="odd" align="center">&nbsp;</td>

<td nowrap class="odd" align="center">&nbsp;</td>
<td width="85%" class="even" align="left"><font class="new-row"><a
href="topic.asp?tid=106110">
Quality ebay auction</a>&nbsp;</font>
<font class="sub-row">in General&nbsp;/&nbsp;The Lounge</font><font
class="sub-row"><br>Started 7/15/2005 - pages <a
href="topic.asp?tid=106110">1</a> - last posted by <a
href="profile.asp?action=view&id=Shandy" onmouseover="window.status='Show
the authors profile'; return true;" onmouseout="window.status=''; return
true;">Shandy</a></font></td>
<td width="15%" class="even" valign="middle" align="left"><font
class="new-row"><a href="profile.asp?action=view&idiscoInferno"
onmouseover="window.status='Show the authors profile'; return true;"
onmouseout="window.status=''; return true;">DiscoInf<BR>erno</a></font></td>
<td nowrap class="odd" valign="middle" align="center"><font
class="new-row">9</font></td>
<td nowrap class="odd" valign="middle" align="left">
<font class="new-row">7/15/2005<br>
<font class="sub-row">5:02:16 PM</font></font></td>
</tr>
----------------------------------------------------------------------------
--------------------------------------------

It's a table which shows the latest posts of a forum. I'd like to pull out
the following information:
Topic: Quality ebay auction
Original poster: DiscoInferno
Started: 7/15/2005
Last Post By: Shandy
Last Post Date: 7/15/2005 5:02:16 PM

This *type* of information is repeated down the web page although the data will change and I want to do this with the whole page.


Any suggestions or sample hint codes ?

Need for C#

pankaj Reviewed by pankaj on 3rd Jul 2010. Extracting data from a string I've extract this from a webpage and stored in a string. ---------------------------------------------------------------------------- ---------------------- <tr height="25"> <td nowrap class="odd" align="center"><img src="/forums/images/icon_topic_new.gif" width=14 height=14 alt='New Topic' border=0></td> <td nowrap class="odd" align="center">&nbsp;</td> Rating: 5

[litewarez]

to be honest i know how to do this with 3 lines of code but im not in the mood to support leaching.

[pankaj]

I am not gonna leech. I am developing a application and I'll need to extract some data and display it.

[litewarez]

Download Simple Dom from Source Forge.

include the file into your application.

And use this code:

//Include file here

//Source
$source = '
tr height="25">
<td nowrap class="odd" align="center"><img
src="/forums/images/icon_topic_new.gif" width=14 height=14 alt='New Topic'
border=0></td>
<td nowrap class="odd" align="center">&nbsp;</td>
<td nowrap class="odd" align="center">&nbsp;</td>
<td width="85%" class="even" align="left"><font class="new-row"><a
href="topic.asp?tid=106110">
Quality ebay auction</a>&nbsp;</font>
<font class="sub-row">in General&nbsp;/&nbsp;The Lounge</font><font
class="sub-row"><br>Started 7/15/2005 - pages <a
href="topic.asp?tid=106110">1</a> - last posted by <a
href="profile.asp?action=view&id=Shandy" onmouseover="window.status='Show
the authors profile'; return true;" onmouseout="window.status=''; return
true;">Shandy</a></font></td>
<td width="15%" class="even" valign="middle" align="left"><font
class="new-row"><a href="profile.asp?action=view&idiscoInferno"
onmouseover="window.status='Show the authors profile'; return true;"
onmouseout="window.status=''; return true;">DiscoInf<BR>erno</a></font></td>
<td nowrap class="odd" valign="middle" align="center"><font
class="new-row">9</font></td>
<td nowrap class="odd" valign="middle" align="left">
<font class="new-row">7/15/2005<br>
<font class="sub-row">5:02:16 PM</font></font></td>
</tr>
';

$html = str_get_html($source);

$topic = $html->find('tr td font.new-row a').value();

//You get the idea..... 

Peace

[pankaj]

I had already stored the extracted web page in a string.

I didn't understood what you did with $topic for finding topic.
Where you specified starting with string and ending with string and extracting the things between both strings ?
How to use a loop and extract "topic" and then again "topic2" from same page which has another same type of string.

$topic = $html->find('tr td font.new-row a').value(); 

By the way, I downloaded that and it has php files in it. How to include it ?

[pankaj]

Posting new reply so that you can focus on this. I just now saw that I forgot to mention I need it for C#.

[litewarez]

You would do something like

$html = get_html('http://site.com/topic.asp?id=2'); //Not sure about the function.

foreach($html->find('table tr') as $tableRow)
{
    //You can now use this like the DOM
    $topicLink = $tableRow->find('td font.new-row a')->val();
} 

This is not regex but Dom traversing, such as jQuery inside PHP.

[Lifetalk]

Edited. Nvm.

[litewarez]

then i cant help if you need it for C# :/

[pankaj]

Okay, if some knows C#, i need this.

Some code for extracting xyz.abc from <a tag><c tag>xyz.abc</c></a>
See in first post what I need to search and how.