help with php regexp

Question

I have table like this -> http://jsfiddle.net/jurisKaste/FvgeQ/

And I need to get array of all those numbers from id column... im using php code and I have so far this piece of code from here. i must use php only! Get number from a string

how could i modify this regexp to get a bit readable array ? so the complete code look like this

    $data = str_replace(",", ".", $data); // $data is that html code from fiddle!
    preg_match_all("/[+-]?\d+[\d\.Ee+]*/", $data, $matches);
    var_dump($matches);

edit: what about this ?

    $data = str_replace(",", "", $data);
    preg_match_all("/[0-9]{5,6}/",$data,$matches);
    print var_dump($matches);

it works for me...

codinghorror.com/blog/2009/11/parsing-html-the-cthulhu-way.html — VolkerK
– VolkerK, Commented Aug 5, 2011 at 8:00
Don't parse HTML wil REGEX, it's evil. Consider this Excellent Answer someone else wrote. — Madara's Ghost
– Madara's Ghost, Commented Aug 13, 2011 at 7:22

ace · Accepted Answer · 2011-08-05 08:03:33Z

2

Try this, it looks for the first td after each <tr then gets the number in between the <td> and </td>

preg_match_all("/\<tr.+?td.+?\>([\d,]+?)\</s",$string,$matches);
print "<pre>"; var_dump($matches); print "</pre>";

answered Aug 5, 2011 at 8:03

ace

7,6513 gold badges25 silver badges28 bronze badges

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

1 Comment

wolf3d Over a year ago

it's data from google spreadsheet structured query, it gives this id with comma... so i cut it out and use this regexp pattern... and it works... in example i have 6 digit id, but it can be 5 digit too... that's why i wrote {5,6} $data = str_replace(",", "", $data); preg_match_all("/[0-9]{5,6}/",$data,$matches); print "<pre>"; var_dump($matches); print "</pre>";

RiaD · Accepted Answer · 2011-08-05 08:06:18Z

0

try it

$xml=new SimpleXMLElement($data);
foreach($xml->tr as $tr){
    echo $tr->td[0];
}

answered Aug 5, 2011 at 8:06

RiaD

47.8k12 gold badges85 silver badges128 bronze badges

Comments

wolf3d · Accepted Answer · 2011-08-13 07:19:10Z

0

$data = str_replace(",", "", $data);
preg_match_all("/[0-9]{5,6}/",$data,$matches);
print var_dump($matches);

answered Aug 13, 2011 at 7:19

wolf3d

1122 silver badges11 bronze badges

Collectives™ on Stack Overflow

help with php regexp

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related