Hello everyone,

First of all sorry for my bad english

I'm trying fm 10 with a very simple friend's database.
I've a fild called Name, that contain two or three words. for example
1. "Antony Lorry Marise"
2. "Mary Anderson"
3. "Peter Alwood"
4. "Arianne Parker"
5. "Louis Cotton"
I've created a script to find all the records that start with the "A"
letter in the field Name. So I expect to find only the no. 1 and 4.
Unfortunately the script find also the records no. 2 and 3, that is the
records that contain a second or a third word who start with the
specified letter "A".
Can you help me?
Thank you
El grillo

el grillo <mail (AT) mail (DOT) com> wrote:

Filemaker finds records with words that start with a A in that field. In
order to find only records with a field text starting with a, you'll
have to search for ==a*

== means the field (not a word) must be ecactly as you say
a means it (the field, that is, see above) must start with an a
* any or no signs may follow this letter

--
http://clk.ch

Christoph Kaufmann ha pensato forte :
WOW!!! Works -- many thanks.
is there on line an explication of all the script?
Thank

el grillo <mail (AT) mail (DOT) com> wrote:

[search for ==a*]
Yes, each function and each script step is explained in the help file.
Your problem is not about scripting, though, it's about using symbols
when searching -> the section you're looking for might be named "find,
sort and replace data" or something.
--
http://clk.ch

Il 10/03/2010, Christoph Kaufmann ha detto :
many Thanks.

"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

Another option would be to create a new Calculation field that stores just
the first letter of the Name field,
e.g.
FirstLetter Claculation, Text Result, Unstored
= Left(Name;1)

and then perform the Find on this new FirstLetter field instead.


Helpful Harry )