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:31:35
 
 
To
12/06/2012 12:02:04
General information
Forum:
Visual FoxPro
Category:
VFPX/Sedna
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01545890
Message ID:
01545894
Views:
60
Thanks - I pasted your example into a Comment on the VFPX wiki page. Maybe others will find it helpful too.


>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)
>
Previous
Reply
Map
View

Click here to load this message in the networking platform