1 Reply Latest reply on Apr 5, 2011 11:36 AM by philmodjunk

    Problem finding duplicates in a text calculation field

    MarkPetersen

      Summary

      Problem finding duplicates in a text calculation field

      Product

      FileMaker Pro

      Version

      10

      Operating system version

      OS 10.6

      Description of the issue

      On a simple duplicate find request (!) on a calculation text field (Indexed, = email & first name), I am not finding some of the identical records in the file and I am finding others.  Any ideas why?

      They are letter for letter, space for space identicle.

        • 1. Re: Problem finding duplicates in a text calculation field
          philmodjunk

          I'd double check the invisible characters that may or may not be spaces in these two fields to be sure. One invisible character different is all it takes here.

          If you are absolutely, positively sure that records with identical fields aren't being found, you might try rebuilding the index on this field to see if that helps.

          To rebuild the index of a single field,

          1. open Manage | Database | Fields and double click the field
          2. Use either the storage tab or the storage options button to turn off indexing.
          3. Exit Manage | Database, then return and turn indexing back on.

           

          You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.

          If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:

          1. With the file closed, select Recover from the File Menu.
          2. Select "Use advanced Options"
          3. Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".