not sure why regex is doing this

From: 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

« previous php.general (#174137) next »