Reg expression help
Posted: Wed Mar 26, 2014 7:47 pm
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):
I simple need a way to replace the 'products' whith another name that doesn't affect 'productskus' and only between <cfquery>
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>