3 Replies Latest reply on Nov 8, 2011 9:04 AM by philmodjunk

    Please help with Finding, Marking, and Deleting duplicates using a script

    jeffbrownell

      Title

      Please help with Finding, Marking, and Deleting duplicates using a script

      Post

      I'm new to filemaker pro and i need help creating a script to find/mark all the duplicates on a database with several hundred thousand entries. I've tried using this script, but i come up with an error at the replace field contents entry.

      Show All Records
      Sort Records [Restore, No Dialog] Sort by Client ID in Ascending order
      Go to Record/Request/Page [First]
      Replace Field Contents [No dialog, 'Mark', " "]
      Loop
      Set Field['Global','ClientID']
      Go to Record/Request/Page [Next, Exit after last]
      If ['Global = ClientID']
      Set Field ['Mark', '"X"']
      Else
      Set Field ['Global','ClientID']
      End If
      End Loop
      Perform Find [Restore] Find records when Mark = X

      .if anybody could offer some helpful advice it would be greatly appreciated as I have almost no idea what to do I've tried multiple scripts from the help section on the filemaker website but nothing seems to be working. I must be making more then one mistake because my scripts never look the exact same as those posted on the website if someone could give me some step by step directions perhaps I'd have more luck. I'm close to running out of time to finish this project so if someone could please respond soon I'd be extremely grateful

       

      thanks

      Jef Brownell