Wildcards and Find

[FM Newbie]

Greetings,

I am using FMP10adv on Windows Server 2003.

I have a field containing one or more of the following characters: SMFOICVPHX (but only one of each), so a particular field could contain S or SM or MS or FM or FMSO or any combination.

I am writing a script fed by checkboxes on a layout to search for all fields containing a character selected by the user.

If I manually go into Find Mode and enter *M* it will find all the correct records.

... but trying to script it as follows (after entering find mode):

Set Field[Table::Field;"*" & LeftValues($values;1)& "*"]

(where the LeftValues($values;1) pulls the M out of the checkboxes)

This does not get the right answer.

Can anyone clue me in?

[comment]

LeftValues() leaves a trailing carriage return. Try the GetValue() function instead.

[FM Newbie]

Fantastic, Thanks! It Worked.

(where would I find that level of detailed documentation about the various functions and their specifics?)

[comment]

In the functions reference section of the help file. It's far from being perfect, but this particular oddity happens to be mentioned.