not sure why regex is doing this
| From: | craig | Date: | Fri, 09 Jan 2004 16:53:56 +0000 |
| Subject: | not sure why regex is doing this | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-174137@lists.php.net to get a copy of this message | ||
Hi,
I have a text file that I have to parse and insert into a db.
these are a couple of sample lines (they are part of the
variable $query)
(4536,'golf tournament management',430,0,0),
(1434,'Premium golf balls',,,0),
I have to replace the blank entries (,,) with NULLs,
and I am using this regex:
$query = preg_replace('/,\s*,/',',NULL,', $query, -1);
after this line, only ONE of the ,, sets is replaced
by ,NULL, like this:
(4536,'golf tournament management',430,0,0),
(1434,'Premium golf balls',NULL,,0),
So, my problem is that I have to run the regex twice to
replace both sets of ,, with ,NULL, and I really don't
want to do that. Why isn't it getting them both with the
first regex, and how should I modify it to catch them
both?
TIA,
Craig