Searches in FIleMaker are "word" based. a-b, a+b and a +b are treated as two words, not one. Space, + and - are all "word separators".
Search criteria as a*b is used to find "a word" where the first letter is "a" AND the
firstlast letter is "b". That, in turn, only finds ab and acb in the example data that you have posted.
I would like that Filemaker improving the search. It is very frustrating to have this poor search engine
OK, but it is still an issue because if I search just for - or + it finds the correct records.
So, that means it can search for other printable characters, not just letters and numbers.
BTW. I was reading all manual to find how FM search and I did not find what you say (search words). do you know where it is written?
OK, but it is still an issue...
But not one that the TS folks that monitor this thread can do much about as they will tell you that it is working "as designed". If you use the link I provided, at least you will be putting your feedback where FileMaker expects to get feature requests and thus it might be seen by someone who can do something about the issue.
do you know where it is written?
I do not. It's something that I've learned over time working with FileMaker and from sources such as this forum.
Thank you for your posts, and I apologize for the late reply.
The design was changed in FileMaker Pro 7. In order to find your records, place "==" before your search. For example:
==a*b ... 8 records
==a@@b ... 4 records
==a@* ... 8 records
==a*@ ... 8 records
==a*@b ... 7 records
Many thanks, TSGal
even if it is difficult for me to understand the logic behind it, it works.