Can you confirm that this field is of type text and not number?
Using FileMaker 11 on my windows XP system, if I enter into Find mode and type A...Z in a name field, I find all names starting with A through Z, and if I create a record where 111 is in the name field, that record is not found.
Yes, this field is a text field. I added ZZ as a name and Z as a name. When I find using "A...Z" it find the Z but not the ZZ name.
I have the following names in my table:
When I enter Find mode and enter A...Z (no quotes)
I get all the names shown above except 111
Okay...I started a brand new dataset table. Only variable is a name field as a text field. I have the following in my names in my dataset:
I do a find on a...z (no quotes) and it finds 5 out of the 6 (it eliminates zebra). ??????
Are you doing this manually or in a script?
What version of windows? (Just trying to nail down any possible differences here.)
I also tried both lower and upper case letters and both work the same.
I am doing this manually (no script)
I am doing this in Windows 7 (64 bit); Filemaker 11.0v3 1-25-11.
I had my IT guy try it on a Windows 7 (32 bit) and the same thing happens. We added the names:
We tried both lower and upper case letter (A...Z and a...z) finds and the results are the same. Just finds the name Z, Marcus, Andy. We also tried (A..Z and a..z) and still it only finds those 3 names.
The only difference here, between you and me that I can see is that I am using Windows XP where you are using 7. If you have an older XP machine that you can play with, it might be interesting to test and see if you get the same results I do on that machine--and this would strongly suggest that there is some difference inherent between Windows 7 and other platforms that needs to be investigated.
What results do you get if you use: a*...z* ?
I get the same results as just using the letters, but maybe it's a work around you can use in 7 to get the needed results.
The a*...z* seems to work. I will try to find Windows XP loaded with Filemaker this week to try it. I'll let you know. Thanks.
Let me know what you find out. I can drop a line to the tech folks at FileMaker asking them to look at this thread if they don't do that on their own.
Thank you for your post.
Remember that a range takes you from the first value to the last value, inclusive. With a range set from a..z, you are finding all values between "a" and "z", inclusive. Anything greater than "z" will not be found, and that would include "zebra" or anything else that begins with the letter "z". If you want all entries that begin with the letter z, then you would need to set the range as: a..z* or a..zzzz
PhilModJunk - I'm unable to replicate your findings on Windows XP. Is it possible you have other words in the text field?