Keyword text searches

[poulsotw]

Hello

just wondering if anyone has comments on whether it is possible to include a memo field in a form to hold several paragraphs of text and search this text for key words.

What I would like to do is have a subform to hold a document such as a letter and be able to screen the letter for key words that are held in a list in another field. The idea being that any of the words appearing in the free text are picked up and automatically stored elsewhere in a field on the main form.

I would also need to include word variations within the list of key words but I can cross this particular bridge later.

any suggestions or pointers to known relevant articles very much appreciated,

cheers,
Toby.

 

[Fizzio]

Yes, this can be done using VB code. How you will need to achieve this is
1. Split the list of keywords into separate variables (I generally use an array to store the list)
2. Using the Instr Function, look for each keyword in turn using a for/next or for each loop
3. If keyword is found, store this value in the main form (just out of interest, you already have a list of keywords, how will this second list differ?) - If it is found several times do you want to store it multiple times in the second list?

Hope that gets you started.

If you are new to VB, search here for some code snippets and if you have no joy, post back and I'll have a bash at something for you.

 

[poulsotw]

Fizzio

thanks for your help, I will take a look at this I have a couple VB books which may help me get started. failing this I will drop you a line.

As for the lists - the document forms part of a profile, the idea is actually to register the words that are present in the document as attributes for that profile and allow users to search on those attributes. So the list of key words remains the same - as a reference list - but the list generated by the search is actually specific to the profile and hence stored with the profile so can be viewed on the form.

cheers,

Toby.

 

[Fizzio]

Ok, I understand you now. Good luck and get back with any specific questions.