Hi,if anyone can help that would be much appreciated.

I have a script that goes to a report of the current record. I do that by copying and pasting the current records group name.

PROBLEM: when the script performs the find on the group name I need it to find the exact match, how do I do that?

Don't use copy and paste. Grab the group name using Set Variable[$GN; GroupName]. Put it into the find by using Set Field [GroupName; "==" & $GN].

The "==" indicates an exact match.

Thank you so much for responding, it's a great thing to know and it worked perfectly.

Another way, not necessarily better but it feels easier to me (and can allow more flexibility if more modifications need to be done to it) ...

Enter Find Mode [ pause ] ... to accept user input

Modify Last Find

Set Field [ thatField ; "==" & thatField ]

Perform Find [ ]

One should of course, include the proper error trapping etc.

Edited December 13, 200718 yr by Guest

Ooops, sorry, I didn't see you copied it first. Firstly, I'd try to leave your clipboard intact and use a variable or script parameter (DJ gave you one). But if you needed to modify the theory of my script, it would be:

Copy [ Select ; table::thatField ]

Enter Find Mode [ ]

Paste [ Select ; table::newField ]

Set Field [ thatField ; "==" & newField ]

... and, just because I provide a method for using copy/paste does NOT mean I suggest it. Like DJ and a thousand other Developers, I suggest strongly against it. But as long as the User performs this action and is aware it interfers with their clipboard, it can be okay I suppose. I'm only giving the option because I didn't properly read the first request about going elsewhere before performing the find.

My prior script is great when you want to modify a User-initiated find.

Thanks Friend.