Regular, Exact & Field Content Searches

From Dwayne Wright PMP - Certified FileMaker Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

In this example, we want to illustrate the differences between a regular find, an exact match find and a field content match find. In our example file, we have 3 records. We have company names of Bob Jones Company, Bobblehead Company and Bob. Yes, we have a company called Bob ( it could happen!).

The regular find is looking for Bob and will show a found set of all three records.

The exact match find is looking for Bob also but there is an equal sign in front of the word Bob. This means we are looking for an exact match of the word Bob. This will return two records of Bob Jones Company and Bob. The Bobblehead Company record was omitted from the found set.

The field content match find is looking for Bob also but there is are two equal signs in front of the word Bob. This means we are looking for and exact content match of the word Bob. This will return the one record of Bob. The Bob Jones Company and The Bobblehead Company records were omitted from the found set.

= Exact Match searches for exactly matching strings or better yet, for each full word match for each word specified.

== Field Content Match
This is used for finding matches exactly how you typed in your search settings.

NOTE: For case sensitivity when searching for text information, you will need to index the field in ASCII ( see indexing discussion for details ).

An example file can be downloaded by clicking (here)

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.