Results 1 to 3 of 3

Thread: Need Help

  1. #1
    Join Date
    Nov 2012
    Posts
    20

    Unanswered: Need Help

    Hello everyone,

    I am grateful for this forum and specially for user of BD on this forum for their support in the past.

    I have duplicate records as show below with the following fields:

    ID,firstname,lastname,address,city,province,postal code

    123, John,Smith, 123 Main Street,Toronto,ON,M1S1S
    435, John,Smith, 123 Main Street,Toronto,ON,M1S1S
    657,John,Smith, 123 Main Street,Toronto,ON,M1S1S

    I would like to write script to compare first name, lastname, city, province and postal and if they are the same, then replace the ID and the result should look like below:

    123, John,Smith, 123 Main Street,Toronto,ON,M1S1S
    123, John,Smith, 123 Main Street,Toronto,ON,M1S1S
    123,John,Smith, 123 Main Street,Toronto,ON,M1S1S

    Any help on how to accomplish the above is greatly appreciated.

    Thanks!

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    See attached file.

    Select any John Smith record displayed, and then press the Check ID button.

    Regards
    James
    Attached Files Attached Files

  3. #3
    Join Date
    Nov 2012
    Posts
    20
    Hi James,

    Much appreaciated as always.

    Worked perfectly.

    Thanks

Posting Permissions

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