Extract Keywords from a document or text field

H. Cody Ross

unread,

May 29, 2002, 9:24:27 AM5/29/02

to

Good Morning,

I'm trying to find a way to extract keywords from a text field, i.e., I want
to paste resumes into a field and then have another field list whether
certain keywords exist such as Skill Set being Excel, VBA, etc.

Any thoughts?

Cody

Tom Fitch

unread,

May 29, 2002, 6:24:12 PM5/29/02

to

Case (PatternCount(resume, "Excel"), "Excel" & "PP") &
Case (PatternCount(resume, "VBA"), "VBA" & "PP") &
etc.

(PP = the paragraph symbol)

Tom Fitch
Fitch & Fitch
Portland, Oregon

H. Cody Ross

unread,

Jun 2, 2002, 11:42:47 AM6/2/02

to

Thanks Tom...that worked perfectly. If I may ask a related question: Is
there a way now to have my end user input a list of values on a form or in a
separate database that will then use those values for the extraction, rather
than have the end user modify the calculation? Perhaps a Loop of some sort
or something like that?

Thanks Again, Cody

"Tom Fitch" <t...@DO-NOT-SPAM-fitchandfitch.com> wrote in message
news:tom-AB0023.1...@netnews.attbi.com...

Chris Brown

unread,

Jun 2, 2002, 9:31:01 PM6/2/02

to

Hi Cody,

to deal with variations on a theme, there are a couple of ways. The easier is
to use a multiline key. Enter the variations, one per line in the field i.e
values separated by carrige return. e.g.:

Excel
Excell
xcl

Create a rel between the multiline key and the text field target.
create a calc field based on the rel, use case statement, or if
if count *1, "Excel"

The same approach can be used for multiple conditions.

To assess multiple conditions e.g. Excel, VBA, use either multiple keys (rels)
one for each condition and then some calc, or case with multiple arguments
using and
combined with patterncount...

regards

Chris

--
Chris Brown
Dept. Neurosurgery
University of Adelaide

Tom Fitch

unread,

Jun 4, 2002, 8:36:33 PM6/4/02

to

Sure thing. There's bound to be other ways to do this, but this one
should work if I understand your problem. Set up some global fields,
then change my previous calc to this:

Case (PatternCount(resume, gField1), gField1 & "PP") &
Case (PatternCount(resume, gField2), gField2 & "PP") &
etc.

Tom Fitch

H. Cody Ross

unread,

Jun 4, 2002, 10:31:12 PM6/4/02

to

The problem with what your suggesting is that I still would have a "limit"
on the number of keywords based upon how many Case statements I put in the
calculation. Perhaps if I word it in a different way:

I would like my end user to be able to put in as many keywords as they
want...there is the potential for up to 100 or more possible keywords. Is
there a calculation that I could use that would loop through another
database of nothing but keywords looking for all the keywords that exist in
the current field?

Something like:

Calc field Loop until last record in the KeywordDatabase
If(CurrentFile:ResumeText has KeywordDatabaseRecord 1 value, then return
the value from the keyword database into the Keyword Exists field in the
current database)
Then it would go to the second record value in the KeywordDatabase until it
has looped through all the possible keywords and returned the existing ones
into the Keyword exists field.

My end user is starting a Headhunter recruiting business and I was trying to
come up with a way to automatically extract whether a person has on thier
resume that they are experienced in, say, Excel, Programming, C++, etc.,
with any limitless possibilities that the end user would want to know. The
list could be extensive. I know that I could do a calculation like that
inVBA for Excel, but was hoping that I can do it in FMP 5.5

Am I asking too much?

Sorry for the long message. Thanks Again. Cody

"Tom Fitch" <t...@DO-NOT-SPAM-fitchandfitch.com> wrote in message

news:tom-C2FD67.1...@netnews.attbi.com...

Chris Brown

unread,

Jun 4, 2002, 11:27:32 PM6/4/02

to

again,
if you use a multi line key, you could even have a separate db for the
keywords, with a value list.
Then a single key field in the parent based on using valuelistitems function
(of the keywords VL) populates the field, with all the record keyword values
in the keyword db, separated by carriage returns: the left side of a multiline
key.

"H. Cody Ross" wrote:

--

Glenn Schwandt

unread,

Jun 5, 2002, 10:56:26 AM6/5/02

to

Create a new database called KeywordList. Add two fields:

Constant (calculation, number) = 1
Keywords (text)

In your current database, add two fields:

Constant (calculation, number) = 1
Search (calculation, text) = Substitute (ResumeText, " ", "ś")

In your current database create two new relationships:

"Edit" between Constant and KeywordList / Constant. Allow adding records
for this relationship. Use a portal based upon "Edit" to manipulate the
list of keywords.

"Match" between Search and KeywordList / Keywords. Create a value list
called MatchList in your current database based upon the values in
Match::Keywords. Add a field in the current database that turns the values
in that list into your desired results:

Keyword Exists (calculation, text) = Substitute (ValueListItems (Status
(CurrentFileName), "MatchList"), "ś", ", ")

This is not very multi-user friendly (only one keyword list), but could be
converted if necessary.

"H. Cody Ross" <code...@bellatlantic.net> wrote in message
news:QJeL8.35502$m9.3...@nwrddc02.gnilink.net...

H. Cody Ross

unread,

Jun 9, 2002, 10:07:57 PM6/9/02

to

Thanks Glenn & Chris,

I followed your design suggestions and everything is working perfectly. I
became involved in another area of the database and tonight was the first
opportunity I've had to apply your suggestions.

Thank You Very Much!

Cody

"Glenn Schwandt" <schwa...@aoldot.com> wrote in message
news:ufs9l2m...@corp.supernews.com...