Splitting a description down into single words

[JaneB19]

Hi,

I'm hoping that somebody can help me!

I have a database made up in access with about ten tables, all but two of them have only two fields. One field is a primary key and the other is a list of what’s in the table.

One of the other tables has a long description in it with key words that appear in some or all of the other tables.

And the final table links all of the primary keys that appear in the other tables.

What I want to do is read the long description in the main table, a record at a time, and then compare the words in the description to key words in other tables, finally inputting the foreign key into the appropriate cells in another table.

If a word matches, the primary key from the table the word comes from will get inserted into the link table under the correct field and the primary key that the description came from will go in the link table as well.

This has to be repeated for all the key words that appear in the first description. Each new entry will be put into a new row in the link table. After all the key words have been matched from the first entry the process has to be repeated with each entry I the table that carries the description.

Hopefully someone can make sense of this and I look forward to hearing back with some positive news!

Thanks in advance

Jane

 

[MichaelRed]

see the ubiquitous {F1} (aka Help) with the key word SPLIT, at least for a start on breaking the text into single words.

As far as comparing each word in the results to numerous other tables, I would guess that, JUST from the question you are asking, that this (project) will be somewhat of a challenge. I would suggest that the individual words from your "long" field be entered into a database table. From there, I would think you could do some queries to select the tables which have hte words in common and use that as an update to your new table. Alas, I am also guessing that this is somewhat abstract for your use.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Craig0201]

Been there, got one of those.

A fully functional Internet style search engine in Access forms using paired inverted files. Complete with phrase searching and wildcards. Yummy. But bloody hard work. The chances of me posting the code for the class modules on here approximates none!

Craig