Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Regex and multiple word search
Message
 
 
À
09/07/2009 07:49:54
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01411109
Message ID:
01411114
Vues:
54
I'm not sure what you're expecting to gain from using regular expressions in this case unless you are looking for whole words not just partial matches. Anyway, regular expression do not support such kind of search in one expression.
You may want to check Thread #1410639 Fastest way to check memo field for a string

>given that activity is a c(100) field in a table
>
>what is the best way to find records where several words are present but not necessarily together
>
>eg:
>
>mouse+trap+living room
>i want to find all occurrences where 'mouse' is existing as well 'trap' and 'living room'
>at the moment i have something like
>'mouse'$activity and 'trap'$ activity and 'living room'$activity
>
>which is kind of cumbersome once there are more than 3 phrases
>I hope there is a way to do that with regex???
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform