Regular expression question

From: Date: Thu, 11 Aug 2005 08:20:39 +0000
Subject: Regular expression question
Groups: php.general 
Request: Send a blank email to php-general+get-220412@lists.php.net to get a copy of this message
Hi I would like to convert from one naming convention within a sql statement to another. I have the following, <code> $str = "insert into userComment (userID, userName, userSurname) values (0, 'Leon', 'Vismer')"; $match = array( "/([a-z]+)(ID)/", "/([a-z]+)([A-Z])/" ); $replace = array( "\$1_id", "\$1_\$2" ); $nstr = preg_replace($match, $replace, $str); echo $nstr ."\n"; </code> the above gets me to insert into user_Comment (user_id, user_Name, user_Surname) values (0, 'Leon', 'Vismer') however I want to get to insert into user_comment (user_id, user_name, user_surname) values (0, 'Leon', 'Vismer') Some help from the regex experts ;-) Many thanks -- Leon

« previous php.general (#220412) next »