Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2012
    Posts
    20

    Answered: I need your help!

    Hello BD users,

    I am trying to write a script and I am having problem and wondering if anyone can provide advise on how to accomplish the following tasks:

    1. I would like to find duplicate records within the same folder (folder name = Contacts) based on the following fields:

    First name, last name, address and email address see example below:

    ID, First name, last name, address, city, email


    Record # 1 - 123, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record # 2 - 234, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record # 3 - 567, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record # 4 - 234, John, Smith, 200 any street name, any city, johns@johnsmith.com

    Based on the above criteria, identify John Smith as a duplicate record & replace his ID numbers as shown below:


    Record# 1 - 123, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record# 1 - 123, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record# 1 - 123, John, Smith, 100 any street name, any city, johns@johnsmith.com

    2. Now move the duplicate records to another folder (folder name=duplicate records). The end result should as follows:

    Record # 2 - 234, John, Smith, 100 any street name, any city, johns@johnsmith.com
    Record # 3 - 567, John, Smith, 100 any street name, any city, johns@johnsmith.com

    Thank you in advance for helping on this task.

  2. Best Answer
    Posted by Tubbritt

    "Hello.
    No problem, see attached file.

    Regards
    James"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    What do you mean ' another folder' ?
    Data is in a table, and the table is in a database.

  4. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Hello.
    No problem, see attached file.

    Regards
    James
    Attached Files Attached Files

  5. #4
    Join Date
    Nov 2012
    Posts
    20

    Help

    Quote Originally Posted by ranman256 View Post
    What do you mean ' another folder' ?
    Data is in a table, and the table is in a database.
    I meant to create another instance of the duplicate records in a separate folder.

  6. #5
    Join Date
    Nov 2012
    Posts
    20
    Hi James,

    As always thank you for your prompt response. I can't open the file now and will try testing it later.

    Thanks!
    Mohammed

  7. #6
    Join Date
    Nov 2012
    Posts
    20
    Hi James,

    This is exactly what I needed so thank you so much for your continous support.

    Mohammed

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •