A basic approach to this (in pseudo-code):
Read a list of keywords into a variable
Read a keyword list ID into a variable
# [ that could indicate keyword type ]
Find relevant company records
Go to Record [ first ]
# [ record loop ]
If [ record is not marked processed for that keyword list ID ]
Read scraped text into variable
# [ keyword loop ]
Get keyword for iteration
If keyword in scraped text [ PatternCount(), or Position() ]
take action [ e.g. create related record in a CompanyKeyword table for keywordType and found keyword ]
Exit Loop if [ keywordCounter = keywordCount ]
Mark record as processed for keyword list ID
Go to next record
For example, if any keywords in the list indicating appropriateness of content (to detect profanity, sexual content, etc.) are found in the scraped data for a company, the field for content appropriateness in the profile of that company should read "Inappropriate Content".
You would be better off having a dedicated table related to Company into which you write records that indicate the (type of) keyword, and the company's status regarding that keyword. (As indicated in the sample code above.)
I'm a newbie to FileMaker, so I'll need to read up and watch some videos on using loops, variables, etc. to hopefully figure this out and give it a try. I really appreciate your time answering the question.
I'm a newbie to FileMaker, so I'll need to read up and watch some videos on using loops, variables, etc.
It can also be helpful to set up a small sample database with just a few fields (so you're not overwhelmed by details) and try stuff out.
Don't hesitate to come here and ask for assistance if any concepts are (or remain) unclear