Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to search memo fields
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00142607
Message ID:
00142654
Views:
22
>Does anyone know of a FAST way to search a memo field for a string. (say look for the string "System testing problem" in a memo field for all records in a DBF)

For free I would try this:

use werreur
scan
copy memo mWerDetail to detail.txt
create cursor Lines (Line c(254))
append from detail.txt sdf
select Line from Lines where "System testing" $ Line into cursor Found
scan
? trim(Line) && Do what you want with the line!
endscan
? "--------"
erase detail.txt
endscan
François Dagenais
LAGIBERT Informatique
Previous
Reply
Map
View

Click here to load this message in the networking platform