Indexed tables

[lebronletchev]

Hello,

One way to do this:

You grab the words from a text file or memo field and stick them in another table. Let's say you have n records containing memo fields. You create an index table of keywords where each of these memo fields has certain number of records in the keyword table exactly as the number of words in it.

Memo Table
Rec Memo

1 Hello World
2 My name is Lebron

Keyword Table && you have to create this table
1 hello
1 world
2 my
2 name
3 is
4 lebron

Now you must search match words in keyword table.

Taking into consideration you have a third table with these data:

source table

ID Names
100 hello world
101 my name

How do you find for exact match in tbale of keywords for output memo table? Hard() Easy() Impossible()

Thanks

lebron letchev

 

[Mike Lewis]

Lebron,

What you have described sounds very much like a product called PhDbase. I don't know if it's still around, but it was very popular at one time.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[lebronletchev]

Mike,

I saw the PhDbase is available on Universalthreads. For downloading I would need subscribe me. Could you talk me more about this Phdbase? what it does? It does a search like my example? depending on your resources I would subscribe UniversalThreads.

The problem is not money, but programming resources!

Thanks

Lebron

 

[Mike Lewis]

Lebron,

I haven't looked at PhdBase for many years, but as far as I remember, it indexes every word in a given memo field, and provides a way for users to search on combinations of words (using boolean and relational operators). It also supports a stop list (to exlude common words line "and" and "the").

I'm sorry I can't really tell you anything else. I don't know whether or not it would justify the cost of subscribing to UT -- except to say that UT offers many benefits, and the subscription is usually worthwhile.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[lebronletchev]

Subscribe a VFP resources may worthwhile than buy a book. I was thinking in to buy a book...

Thank you.

Lebron

 

[NasibKalsi]

if file size is not big you can try
at() function for searches