>Check out this new wiki page I wrote on Performing "AND" and "OR" searches in GoFish:
>
>
http://bit.ly/And-Or-Searching-With-GoFish>
>Caution – You’ll be exposed to Wildcard Searching and Regular Expressions, but don’t let that scare you… I think I boiled it down to something that will be easy to follow and may help you in performing some fancy code searches one day.
>
>
>.
Matt,
Concerning
So, the RegEx syntax for “select” and “from” on the same line is:
(?=.*select) (?=.*from)
This is called Zero-width positive lookahead assertion
There'a also something like 'Zero-width negative lookahead assertion'
Example
I want
select and
from and not
intoThen you use
(?=.*\bselect\b)(?=.*\bfrom\b)(?!.*\binto\b)
Gregory