it seems that * doesn't match numbers while Filemaker says * will match zero or more characters
No, that is not a correct conclusion. The real reason why this doesn't work as you expect is this:
"a.atk" is one word;
"5.atk" is two words.
By default, Filemaker looks for words that start with the search characters. Searching for *.atk looks for words that end with ".atk". This will NOT find "MVI_1245.atk" because it has no word that ends with ".atk" - the words here are MVI, 1245 and atk.
Numbers (digits) are matched with the # character. If a field is number type, I tend to look for ">=0" if no negative numbers are in the field. If I need to look for a negative then "<0" will work.
Can you give us an example of what you are searching for, fmpvince?
On 23 Jan 2012, at 7:14 AM, Michael Horak wrote in whole or in part:
created by Michael Horak in Performing Finds - View the full discussion
I see your searches now (email doesn't seem to always send info through!)
Try this *".atk"
Thanks beverly, it doesn't work either.
But even if did work that's still a bug. I'm not looking for a workaround, I'm lookng to report this bug (if it's one indeed). It seems to me as it's a bug since this is a behavior that can't be expected according to the documentation.
I differ, a number is a Character. But the indexing part is right.
I should have typed ==*.atk which works because it escapes the index