I hate Regex

[eluser]meigwilym[/eluser]
Not being an expert either, but I don't think that you need much regexing for this.

Take the first line for example, you need to match a string that starts with '<B><A ><FONT COLOR=”#00000” SIZE=“2” FACE=“arial”>' and ends with '</FONT></B>'. Thank simply remove them from the string, and what you have left is the column title.

Code:

<?php

# string
$s = 'klhklghfdjskg <B><A NAME="999999999"><FONT COLOR="#00000" SIZE="2" FACE="arial">ColumnTitle</FONT></B> fdsfsdf dfsdf ';

# expression
$p = '/<B><A NAME="999999999"><FONT COLOR="#00000" SIZE="2" FACE="arial">([a-zA-Z0-9 ]*)<\/FONT><\/B>/';


preg_match($p, $s, $m);

var_dump($m);

The above code will return

Code:

array(2) {
  [0]=>
  string(88) "<B><A NAME="999999999"><FONT COLOR="#00000" SIZE="2" FACE="arial">ColumnTitle</FONT></B>"
  [1]=>
  string(11) "ColumnTitle"
}

I'm sure you can pick the rest of it up.

Here's an excellent tutorial and cheatsheet

http://neverfear.org/blog/view/Regex_tut...___Part_1/

http://www.addedbytes.com/cheat-sheets/r...eat-sheet/

Best,

Mei