Re: Regular expression question

n Thu, 11 Aug 2005, Leon Vismer wrote: > 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 ;-) Just a quick note; why dont' you search on "user" since it's the constant and replace 'user[A-Z]' with 'user_[a-z]' or in the case of userID 'user[A-Z]{2}'