AnsweredAssumed Answered

Find Duplicates (!) matches by duplicate paragraphs

Question asked by philmodjunk on Dec 15, 2010
Latest reply on Feb 1, 2011 by TSGal

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.)

Outcomes