...

View Full Version : Regular Expressions



Running Bear
12-15-2003, 03:10 PM
Hello,

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'


Here is my pattern so far -


"(^\s+|[\s(,])(" & key(i) & ")(\s|\)|\,|$)"

any help or ideas will be gratefully received

Cheers Al



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum