How do you do an exact find?

[BigZilla]

I currently have a script;

Copy [AutoGroup]

Go to Layout [DataEntry]

Enter Find Mode

Paste [AutoGroup]

Perform Find

[Replace Found Set]

Enter Browse Mode

My problem is this. If the name is "Smith Dealerships". I get "Smith Dealerships", Chad Smith Dealerships, Smith Brothers Dealerships etc.. How can I rewrite the script to only pull, in this case "Smith Dealerships"? The find selection is made from a pick list, so the name entered is always correct.

Thanks for your help,

B. Zilla

[Lee Smith]

Hi Zilla,

Try this:

Go to Layout [ original layout ]

Copy [ AutoGroup]

[ Select entire contents ]

Enter Find Mode

Insert Calculated Result [ AutoGroup , "=" ]

[ Select entire contents ]

Paste [ AutoGroup]

[ No style ]

Perform Find

[ Replace Found Set ]

HTH

Lee

[BigZilla]

Thanks Lee, that's the ticket!

[BigZilla]

Hi Lee,

Maybe you could help me one more time.

With the above script it works fine except when the following happens.

If the find is "South Shore NJ" the script also picks up "South Shore ML NJ". Is there a way that it will find "South Shore NJ" only!

Thanks Lee,

[Lee Smith]

Try changing the one "=" to two "=="

[BigZilla]

Hi Lee,

I changed it to "==" and it still pulled up both Shouth Shore's.

[Lee Smith]

You need to "Replace" the find when the widow comes up. Open the script again and then click OKay. A window will then come up and ask if you want to Replace of Keep the Find. choose the replace and that should do it.

Lee

[BigZilla]

I did the replace and it still finds both dealers.

[Lee Smith]

You have something else in your script that is overwriting your current find. Check the go Enter Find Mode and Uncheck the buttons there.

Lee

[BigZilla]

Lee,

"Enter Find Mode" in the script have both the "Restore Find Request" and "Pause" UmChecked and the script still does not work.

[slstrother]

What version of Filemaker are you running? The exact find feature is available starting with version 4. However, it is not available in version 4 if the file is hosted on Server 3.

[BigZilla]

I use version 6.0

[Lee Smith]

Open it up again.

physically select each step and make sure that all checkboxes are uncheck EXCEPT the "Select the Entire Content" box in the insert calculated result step and then Check the "Replace" find in the confirmation box that comes up when you click OK and then Click OK.

I can send you a sample of this if you need it.

Lee

[Rangoon]

Hi Bigzilla,

This will work for you every time and will not get you into trouble later.

Create "gAutoGroup" and make it a Global Text field and the script will look something like this;

Go to Layout [Data Entry]

SetField [gAutoGroup, AutoGroup]

Enter Find Mode

SetField [AutoGroup, "==" & gAutoGroup]

Perform Find

[Replace Found Set]

Can life get any better!

hj