Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New wiki page - Performing AND and OR searches in GoFish
Message
From
12/06/2012 12:02:04
 
 
To
12/06/2012 11:34:35
General information
Forum:
Visual FoxPro
Category:
VFPX/Sedna
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01545890
Message ID:
01545891
Views:
70
>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 into

Then you use
(?=.*\bselect\b)(?=.*\bfrom\b)(?!.*\binto\b)
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform