Find Duplicates (!) matches by duplicate paragraphs
Mac and Windows
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.
Say you have two records with the following text fields:
This is the first paragraph of the first record
This is the first paragraph of the second record
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".
Since FileMaker help states that using this operator on a text field "matches by the first 100 characters", that no duplicates would be found.
Records are found as duplicates, even though they aren't.
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.)
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:
I have sent your post along with my findings to our Development and Software Quality Assurance (Testing) departments for review.