I have a regex to replace some SQL criteria with a more user-friendly label on a report.

The SQL where clause is (and, yes, there is a reason for the extraneous parentheses here which I won't bore you with):

AND ((P.NCG_FIS_MGR IN ('H', 'I')))
[download]

My regex is:

$sub_name_for_codes =~ s/AND \(\(P.NCG_FIS_MGR IN \('.*'\)\)\) / 
                         AND Fiscal Manager Name like $fis_mgr_name_va
+lue /g;
[download]

This regex is apparently being skipped because no substitions are being made.

The following works fine:

The SQL WHERE clause:

AND P.PROJECT_ID IN ('521590', '529302', '529808', '528230') AND I.NC_
+NAME LIKE 'Thom%'
[download]

using this regex:

$sub_name_for_codes =~ s/AND P.PROJECT_ID IN \('.*'\) AND I.NC_NAME LI
+KE / 
                         AND Investigator like /g;
[download]

Any suggestions where I've wandered off the path would be appreciated. Thanks!

Lori

Previous content restored above by GrandFather

I was going to ask a question about why a regex wasn't working and forgot to put the '\' in front of the parentheses to make it escape. Sorry for the inconvenience.