Query a string

[klameer]

I want to query a memo field. For example, if I have a table containing the

following fields

ID(Type Number) Details(Type memo)
100 "Cannon bubble Jet printer model 100"
125 "HP lexmark printer model 300"
150 "Cannon lazerjet printer model 200"
175 "Lexmark lazer printer model 678"


if I do the following searches I will get the following results


Search:

Details = "Cannon"
Results
ID Details
100 "Cannon bubble Jet printer model 100"
150 "Cannon lazerjet printer model 200"


Search:
Details = "Lazer"
ID Details
150 "Cannon lazerjet printer model 200"
175 "Lexmark lazer printer model 678"



Search
Details = "HP"
ID Details
125 "HP lexmark printer model 300"


Search

Details = "Model 100"
ID Details
100 "Cannon bubble Jet printer model 100"


This should be possible because this is the way websites work.

 

[sleipnir214]

Get your search value, open the file, then perform a test on each line if the file to see if your search pattern appears in the line. If it does, print the line.

Then close the file. ______________________________________________________________________
Perfection in engineering does not happen when there is nothing more to add.
Rather it happens when there is nothing more to take away.