6 Replies Latest reply on Feb 22, 2012 2:08 PM by philmodjunk

    a Find does not find all records in a Name field which has embedded apostrophes

    ronugent

      Summary

      a Find does not find all records in a Name field which has embedded apostrophes

      Product

      FileMaker Pro

      Version

      FM 11

      Operating system version

      Mac OS X, verions 10.6.8

      Description of the issue

      Can't seem to find a way to locate all records with an apostrophe in the name.  Have tried just the apostrophe and combinations  of "'", @', @"'", @*', @*"'".  Substitute also does not seem to work.

      Steps to reproduce the problem

      Shown above.

      Expected result

      To first find the records with an apostrophe in the name and then remove the apostrophe.

      Actual result

      Names are not found and apostrophe is not removed.

      Exact text of any error message(s) that appear

      No error message appears.  Desired result is just not achived.

      Workaround

      Have had to do it manually.