string searching problem

[michaelvleugel]

Hi,

I'm having a problem: Someone has a HUGE table in a html page and wants to insert the data of that table into a database (makes perfect sense - this guy inserted the data manually...)

One table cel contains an email address, an url and some blabla.

I have no problem turning the entire contents of one cel into one variable (used explode and strip_tags for that),

BUT...anyone have a good suggestion how to make PHP filter out the email-address, the url and the blabla? Put those in seperate variables, ready to go into the database?

(NO - I'm NOT trying to build a BOT for unethical purposes here!)

Any help would be gladly appreciated!

[Anon]

How is the data separated within the cell? Another explode could grab things very easily if this someone has a consistent layout in the cells. The trick is to set a limit to explode.

Something like this:

$string = "[e-mail] http://www.zoo.org likes bananas a lot";
list($email,$url,$rest) = explode(" ", $string, 3);