7 Replies Latest reply on Nov 24, 2013 3:32 AM by gcatnine

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

    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)