3 Replies Latest reply on Jul 24, 2014 6:51 AM by philmodjunk

    "Find duplicates" is not working

    wedoshows

      Summary

      "Find duplicates" is not working

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Windows 7

      Description of the issue

      Up until I had a computer crash and had to "recover" all my files I was able to find duplicates, sort and remove them.  Now, my command to find duplicates  (! in the email field)  does not bring up duplicates ... of which there are hundreds.  I know there are hundreds because when I sort by the email field I can visually see the duplicates.  I am combining data from several different FM files to make a master list.  There are fields in some files for only email addresses.  Some files also include fields for first name, last name, address, city, state, zip, etc. 

      Could this problem be related to my computer crash and the recovered files?  Any suggestions on how to resolve this?

      Exact text of any error message(s) that appear

      No error message appears; my search for duplicates only brings up two records.

        • 1. Re: "Find duplicates" is not working
          philmodjunk

               Could this problem be related to my computer crash and the recovered files?

               Very easily. The indexes of your files may not be in good working order. And there might be other ways that a "post crash" file might fail.

               A crash can damage files and damaged files can crash.

               And while Recover usually can both detect and fully repair the damage, there are no guarantees. Recover doesn't always detect damage to a file and recover doesn't always succeed in fully repairing the damage it does detect.

               Your best bet is to take a back up copy made before the crash, save a clone of it and then import all data from your recovered copy into this clone of the file and use it in place of what may be a damaged file.

          • 2. Re: "Find duplicates" is not working
            wedoshows

                 I was excited to get your comments and when I came into the office this morning I cloned a file I had backed up on a CD from 2010 ... well before my computer crash and thought I would have solved the problem ... but NO!  But, I'll try again with another file (perhaps one in FM 12) as the one from 2010 was FM 7.

                 Thanks for your suggestion.

            • 3. Re: "Find duplicates" is not working
              philmodjunk

                   Note that sometimes the data in a field can appear to be a duplicate of the same value in the other field when it is not. The presence of a space after the last character in one field that is not in the other record's field is one such example.