AnsweredAssumed Answered

The * and @ find operators does not find characters that are not letters or numbers.

Question asked by gcatnine on Oct 16, 2013
Latest reply on Nov 24, 2013 by gcatnine

Summary

The * and @ find operators does not find characters that are not letters or numbers.

Product

FileMaker Pro

Version

12

Operating system version

windows 7

Description of the issue

The * and @ find operators does not find characters that are not letters or numbers therefore it is impossible to make simple searches where in the text there are printable characters but not letters or numbers

Steps to reproduce the problem

To test I create a table with 1 text field  7 records.
In the records put:
ab
a-b
a -b
a- b
a+b
a+ b
a +b
acb

find criteria ____records funded
a*________________7  (all)
a*b_______________2 (ab, acb)
a@@b _____________none
a@*_______________2 (ab, acb)
a*@b______________1 (acb)

so the * and @ operators do not recognize the characters “-“ and “+” used in the test, but it seems just recognize letters and numbers.
PS: I use the _ (underscore) instead of tab or space because the system cancel them.

Expected result

in the test all tested criteria should find all records

Actual result

see above

Exact text of any error message(s) that appear

n/a

Configuration information

n/a

Workaround

put several finding criteria (not always possible)

Outcomes