Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago

Query Text Field to Parse Out Key Words and Create Tags

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    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
    ------------------------------
    • AdamKeever1's avatar
      AdamKeever1
      Qrew Commander
      6 years ago
      Thanks for the feedback Mark. I see what you mean for tagging records and will keep that in mind, but that is not what I had in mind.

      I want to quickly (at least more quickly than manually reading the text in all three fields for over 14,000 records) identify key words that appear many times in many records.

      I did something similar once using known key words already associated with the records and then filtering out records that contain those key words. This brought my list of records down to only records with no known key words. From there I added new key words as I came across them and refined the filter and reiterated until the list had at least one key word for each record.

      It took a while, but it worked. I was hoping someone might know of a faster approach or an AI solution of sorts.

      ------------------------------
      Adam Keever
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        So you're not trying to identify key words. What you were trying to do is identify all words and rank them up by the preponderance in usage. Is that a challenge?

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