3 Replies Latest reply on Nov 19, 2009 11:07 AM by comment_1

    Apostrophe not recognized in Filter, Position and PatternCount functions

    kn1ghtman_1

      Summary

      Apostrophe not recognized in Filter, Position and PatternCount functions

      Description of the issue

      FileMaker Product(s) involved:FileMaker Pro Advanced 10.0v3, FileMaker Server 10.0.2.206Operating System(s) involved:Windows Vista Detailed description of the issue:I've found that the apostrophe (') only seems to be recognized by the Filter and PatternCount functions if they're applied to literal text and not a variable or a field reference.Scenarios that reproduce the issue:1.  Create a text field and apply the following calculation: Filter(Self;"dek onr'stw") as an Auto-Enter Calculated Value, uncheck "Do not replace..." and enter "doesn't work" into the field".     Expected Result: "doesn't work"     Actual Result: "doesnt work"2.  Disable the Auto-Enter Calculated Value on field, enter "doesn't work" into the field again, open the data viewer, add a new expression and enter the following calculation: Filter({field name};"dek onr'stw").     Expected Result: "doesn't work"     Actual Result: "doesnt work"3.  Change calculation to: Let(x={field name};Filter(x;"dek onr'stw")).     Expected Result: "doesn't work"     Actual Result: "doesnt work" 4.  Change calculation to: Position({field name};"'";1;1).     Expected Result: 6     Actual Result: 0 5.  Change calculation to: PatternCount({field name};"'").     Expected Result: 1     Actual Result: 0 Scenarios that don't reproduce the issue:1.  Change calcuation to: Filter("doesn't work";"dek onr'stw").     Expected Result: "doesn't work"     Actual Result: "doesn't work" 2.  Change calculation to: Position("doesn't work";"'";1;1).     Expected Result: 6     Actual Result: 6 3.  Change calculation to: PatternCount("doesn't work";"'").     Expected Result: 1     Actual Result: 1 Any workarounds that you have found:None