1 Reply Latest reply on Feb 1, 2011 3:17 PM by TSGal

    Find Duplicates (!) matches by duplicate paragraphs

    philmodjunk

      Summary

      Find Duplicates (!) matches by duplicate paragraphs

      Product

      FileMaker Pro

      Version

      11v2

      Operating system version

      Mac and Windows

      Description of the issue

      Entering a ! into the text field of a find request finds records where a single paragraph matches a single paragraph of another record even though preceding text in the fields are completely different.

      Steps to reproduce the problem

      Say you have two records with the following text fields:

      -------------
      This is the first paragraph of the first record

      abc

      ----------
      This is the first paragraph of the second record

      abc
      ------------------

      Enter find mode and put ! in this field. Perform the find. Both records are found as duplicates due to the fact that the second paragraph in the fields are "abc".

      Expected result

      Since FileMaker help states that using this operator on a text field "matches by the first 100 characters", that no duplicates would be found.

      Actual result

      Records are found as duplicates, even though they aren't.

      Workaround

      After performing a find, sort and compare adjacent records, omitting those that are actually unique, or edit the text to remove the carriage returns separating the text into paragraphs. (Or I suppose you could perform the search on a calculation field that strips out the returns.)

        • 1. Re: Find Duplicates (!) matches by duplicate paragraphs
          TSGal

          PhilModJunk:

          Thank you for your post, and I apologize for the late reply.

          I can confirm this issue on both Mac OS X 10.6.6 and Windows XP SP3.  You can make this simpler by having the two records:

          -----
          First
          abc
          -----
          Second
          abc
          -----

          I have sent your post along with my findings to our Development and Software Quality Assurance (Testing) departments for review.

          TSGal
          FileMaker, Inc.