Page 1 of 1

Reg expression help

Posted: Wed Mar 26, 2014 7:47 pm
by pelfed
Hi

I'm trying to do a find and replace using reg expression.

I need to find all occurance of an SQL field called products: So in lots of files i may have the following (and maybe across multiple lines):

Code: Select all

<cfquery> select * from table1 ts, products ps, productskus psk where etc etc </cfquery>
I simple need a way to replace the 'products' whith another name that doesn't affect 'productskus' and only between <cfquery>