Script to find multiple word match

[schmegol]

I have a complex problem. I have a database of records with a text field that contains a 1 to 5 word phrase such as "winner circle post horse laptop"

I want to search through each record's text field to find and compare another text field for a match of all of the words in the field regardless of the order they are in such as "circle winner laptop post horse" would be a match because the field contains all the words. I would like to reject matches that only contain a partial match of less than the complete word count.

Anybody ever done this or have any ideas?

[schmegol]

I have a complex problem. I have a database of records with a text field that contains a 1 to 5 word phrase such as "winner circle post horse laptop"

I want to search through each record's text field to find and compare another text field for a match of all of the words in the field regardless of the order they are in such as "circle winner laptop post horse" would be a match because the field contains all the words. I would like to reject matches that only contain a partial match of less than the complete word count.

Anybody ever done this or have any ideas?

[schmegol]

I have a complex problem. I have a database of records with a text field that contains a 1 to 5 word phrase such as "winner circle post horse laptop"

I want to search through each record's text field to find and compare another text field for a match of all of the words in the field regardless of the order they are in such as "circle winner laptop post horse" would be a match because the field contains all the words. I would like to reject matches that only contain a partial match of less than the complete word count.

Anybody ever done this or have any ideas?

[bikergeek]

That should be a straightforward find. Unless you quote the search text, FM should parse each word separately rather than as a phrase, and return all the records, and only those records, with all the words.

Make a button with a script:

Set Field [ global ; searchCriteriaField ]

# Or define searchCriteriaField as a global

Enter Find Mode

Set Field [fieldBeingSearched; global]

Perform Find

[bikergeek]

That should be a straightforward find. Unless you quote the search text, FM should parse each word separately rather than as a phrase, and return all the records, and only those records, with all the words.

Make a button with a script:

Set Field [ global ; searchCriteriaField ]

# Or define searchCriteriaField as a global

Enter Find Mode

Set Field [fieldBeingSearched; global]

Perform Find

[schmegol]

That solution will not really accomplish what I'm trying to do.

If my phrase is "dish tv satelllite" and I search It would find reslults of "satellite tv dish" and also "dish satellite tv cable box" if that phrase was there. I am only interested in exact matches of the phrase words including the count of the phrase words and omitting extra words in the match.

[schmegol]

That solution will not really accomplish what I'm trying to do.

If my phrase is "dish tv satelllite" and I search It would find reslults of "satellite tv dish" and also "dish satellite tv cable box" if that phrase was there. I am only interested in exact matches of the phrase words including the count of the phrase words and omitting extra words in the match.

[comment]

If I understand you correctly, you could use another calc field, cWords =

WordCount ( textfield )

Then enter your search phrase in a global field and:

Enter Find Mode

Set Field [ textfield ; globalfield]

Set Field [ cWords ; WordCount ( globalfield ) ]

Perform Find

[comment]

If I understand you correctly, you could use another calc field, cWords =

WordCount ( textfield )

Then enter your search phrase in a global field and:

Enter Find Mode

Set Field [ textfield ; globalfield]

Set Field [ cWords ; WordCount ( globalfield ) ]

Perform Find

[artypants]

you just need the find operator "=" in front of your find phrase like:

"=find this exact phrase"

[artypants]

you just need the find operator "=" in front of your find phrase like:

"=find this exact phrase"

[Vaughan]

="find this exact phrase"

[Vaughan]

="find this exact phrase"