AnsweredAssumed Answered

Setting Variables to Fields with Quotation Marks does not escape

Question asked by SamJaques on Jun 19, 2014
Latest reply on Jun 19, 2014 by philmodjunk

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

Outcomes