... I just don't see it....

I have a field called Symbol

In this field there are these records:

GLD, GRD, etc...

When I search for duplicates, if the user has typed a 'g' in the field and then the script does a FIND, it returns all fields that start with 'g'.

I want it to return just fields that are identical to the search field; ie, 'g'.

How do I do that?

THanks

Edited August 17, 200916 yr by Guest
Corrected subject

I neglected to mention that it is a script driven 'find'. So, ==g won't work.

Anyway, here is the script:

set variable [$stocksymbol; value:stock::symbol]

goto layout ["Stock" (stock)]

view as table

enter find mode

set field [stock::symbl; $stocksymbol]

perform find[]

(hmmm or can I concatenate the "=="&$stocksymbol ??)

Hi,

Instead of script you have exposed:

set variable [$stocksymbol; value:stock::symbol]

goto layout ["Stock" (stock)]

view as table

enter find mode

set field [stock::symbl; $stocksymbol]

perform find[]

try copy-paste:

Copy [stock::symb]

goto layout ["Stock" (stock)]

Enter find mode

Paste [stock::symb]

perform find[]

where field [stock::symb] must be calculation field with text result

"=="&symbol

"Copy-Paste" is not so bad option is such cases.

LARETTA,

thanks for the idea. concatenating the find worked great.

BTW, i tried to rate your idea and couldn't get message ranking to work? any suggestions?

thanks again