Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Regular Expressions
12-15-2003, 04:10 PM #1
I'm witing a script (using VBScript), which will colour code SQL statements. I'm using regular expressions to find matches. When a keyword is found I set the font to blue etc., which I've done, but...
I'm having difficulty telling it not to find matches within single quotes!
for example -
I want it to find -
select t.Start_Dat from Tariff5 t where t.Ref= ... but not - ... t.Ref = 'Hello World <> of where blah, blah'
"(^\s+|[\s(,])(" & key(i) & ")(\s|\)|\,|$)"