Query Text Field to Parse Out Key Words and Create Tags

Question

Does anyone know of a good method to parse out key words from text fields?

I have a table in which I import data from a customer database and there are three text fields that a user has input information. I want to be able to identify key words that occur in these fields across many records in order to categorize the records by the key words or tags.

------------------------------
Adam Keever
------------------------------

MarkShnierYou · Answer

You could set up a new table called KeyWords with a single record in it. The record could have say a column on the form with slots for 20 key words (so 20 data entry) fields and then another column of 20 Categories. You would probably want to have the categories be from a Multiple choice list on the 1st field and then all the rest of the 19 category multiple choice fields would refer back to the original [Category 1] field.

Then using a reference field with the formula value of 1, ( to match up with the Record ID# 1 as the only record in that table), look up the 20 pairs of fields.

Then a giant List(",",
IF(Contains([Field 1],[Keyword 1], [Category 1]),
IF(Contains([Field 1],[Keyword 2], [Category 2]),
IF(Contains([Field 1],[Keyword 3], [Category 3]) etc

to do the tagging.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community