3 Replies Latest reply on Jun 19, 2014 3:37 PM by philmodjunk

    Setting Variables to Fields with Quotation Marks does not escape

    SamJaques

      Summary

      Setting Variables to Fields with Quotation Marks does not escape

      Product

      FileMaker Pro

      Version

      13.0v3

      Operating system version

      Windows 7 Professional

      Description of the issue

      When I set a variable to the value of a text field that contains quotation marks (e.g., $name = James "Jim" Doe), and then I use the variable in a search (e.g., find records where fullname = $name), it will not find the original record because it will use the quotes as search operators, rather than escaping the characters (i.e., it will not search for James \"Jim\" Doe and will not find the original record, at least when doing an exact match.

      Steps to reproduce the problem

      Setting a variable to a text field that contains quotes and then searching using that variable

      Expected result

      It should find the original record that contains the value that was used to set the variable

      Actual result

      It does not find the original record

      Workaround

      None