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?

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?

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?

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

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

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.

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.

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

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

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

"=find this exact phrase"

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

"=find this exact phrase"

="find this exact phrase"

="find this exact phrase"