Extract specific values from HTML table using regex

Question

I have a html file that contains this table row:

<tr> 
<td class="color21 right" style="font-size:12px; line-height:1.2;">&nbsp;Location</td>
<td class="color21" style="font-size:12px;">10</td>
<td class="color21" style="font-size:12px;"><img src="../../icons/9.gif" alt="Type" />     </td>
<td class="color21" style="font-size:12px;">3</td>
<td class="color21" style="font-size:12px;">7</td>
<td class="color21" style="font-size:12px;"><img src="../../icons/11.gif" alt="Type" />    </td>
<td class="color21" style="font-size:12px;">3</td>
<td class="color21" style="font-size:12px;">10</td>
<td class="color21" style="font-size:12px;"><img src="../../icons/9.gif" alt="Type" />    </td>
</tr>

I'm retrieving file contents using file_get_contents.

How can I extract all TD values using preg_match, preg_match_all?

Nambi · Accepted Answer · 2014-04-15 17:06:07Z

1

Use the DomParser to Parse the html content regex are not reliable on this cases.

    $str=file_get_contents('read.txt');
    $dom = new domDocument;
    $dom->loadHTML($str);
    $tr = $dom->getElementsByTagName('td');
    foreach($tr as $td)
  {
    if(!empty($td->nodeValue)){
        echo $td->nodeValue."\n";
    }else{
        $images=$td->getElementsByTagName('img');
        foreach($images as $image){
            echo $image->getAttribute('src')." ";
            echo $image->getAttribute('alt');
        }
    }

edited Apr 15, 2014 at 17:06

answered Apr 15, 2014 at 16:48

Nambi

12k4 gold badges40 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mpet Over a year ago

This works great for numeric values, but I also need image values such as 9.gif, 11.gif... Do you have any suggestion?

mpet Over a year ago

I would be satisfied to get whole img string along with numerical values <img src="../../icons/9.gif" alt="Type" />

Nambi Over a year ago

@mpet i have edited my answer to get the img src along with the values.

Amit Joki · Accepted Answer · 2014-04-15 16:37:22Z

1

Think over if you really wanna a regex to parse html

But you can use this:

<td.+?>(.+?)</td>

The first group will contain the values of <td>

answered Apr 15, 2014 at 16:37

Amit Joki

59.4k7 gold badges80 silver badges96 bronze badges

1 Comment

mpet Over a year ago

What do you suggest instead?

Collectives™ on Stack Overflow

Extract specific values from HTML table using regex

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related