AnsweredAssumed Answered

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

Question asked by ronugent on Feb 17, 2012
Latest reply on Feb 22, 2012 by philmodjunk

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.

Outcomes