Why can't i do an exact match with filemaker pro 8.0. I know with 7.0
you can use == and later versions it went to " *** ". Am I missing
something?

In article <1173308487.504855.206970 (AT) 64g2000cwx (DOT) googlegroups.com>,
joelabdul (AT) yahoo (DOT) com wrote:

I don't know for sure about the newer versions of FileMaker, but in
FileMaker 5.5 and earlier the symbol for "exact match" is a single "=".
A double one "==" would try and find a field with and exact match of
the second "=".

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On 03/07/2007 18:01:27 joelabdul (AT) yahoo (DOT) com wrote:



Exact match has been the same for as long as I can remember: two equals signs (==), as described in Help (both 6 and 8.5).

Matt

In article <371911.WIMNUSDD (AT) news (DOT) verizon.net>, Matt Wills
<I'm (AT) witz (DOT) end> wrote:

Opps! You're right, even in FileMaker 4 and 5.

The single "=" finds words, while the double "==" finds phrases
(multiple words).

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Mar 7, 10:08 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:


The actual problem is I'm trying to search for a single word in a cell
with two words. For example I want "Troy" not "So. Troy". ==Troy
does not work and "Troy" does not work. How's does Happy Harry
Handle my Horribly simplistic harrassing problem.

Let me see, you want all the records that has a field in which ONLY the word
Troy stands and NO other words.

COMPLETELY UNTESTED!

Say your field is: MyField <text>
Create a global field: MySearch <text, global>
Create a calc: cMySearch <calculation, number>

in the calc you have

If ( patterncount ( Myfield ; Mysearch ) = 1 AND ( length ( MyField ) =
Length ( MySearch ) ) ; 1 ; 0 )

Now when you search for a 1 you will find what you need.

Ursus

<joelabdul (AT) yahoo (DOT) com> schreef in bericht
news:1173347184.596252.240590 (AT) t69g2000cwt (DOT) googlegroups.com...

On 03/08/2007 05:19:59 "Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote:

Unless I am missing the issue entirely, ==Troy should accomplish that.

As I have just tested in my own solution:

Find Burlington returns 2 records: Burlington and South Burlington
Find ==Burlington returns one record: Burlington.

Find Rutland returns 2 records: Rutland and Rutland Town
Find ==Rutland returns one record: Rutland.

Matt