UTS Library
Published on UTS Library (http://www.lib.uts.edu.au)

Home > How can I easily find duplicate records in my database and then remove them?

Vote up! [1]
12
UTS Library asked about
RefWorks [2]
1 year ago:

How can I easily find duplicate records in my database and then remove them?

1 answer
6313 views

Answers

  • Most Voted [3]
  • Newest [4]
  • Oldest [5]

RefWorks offers two options [6]

UTS Library's picture [7]
UTS Library, 1 year ago
Vote up! [8]
1

RefWorks offers two options for locating duplicates – exact match and close match. Both options can be found in the View/Duplicates area.

Close Matches - checking is done by comparing a combination of Author Names, Title, and Year of Publication. It is a loose comparison so may result in a display of references that are not exact matches. This allows duplicates to be found even if there are minor errors in the data. Also, depending on the size of your RefWorks database, the Close Matches may take some time, so be patient.

Exact Matches - checks for exact matches based upon the Author Names, Title and Year of Publication fields.

To remove duplicates permanently from your database:

1. Mark the reference you wish to delete by clicking the box next to the Ref ID. These selections are not saved when you go to the next page. So be sure to add the references to a folder before moving to another page.

2. Click Delete.

3. The duplicates list refreshes and the matching records you did not delete, drops off this list (as it is no longer a duplicate).

Answer question [9]
  • refworks [10]

Source URL (retrieved on 23/05/2013 - 06:01): http://www.lib.uts.edu.au/question/5661/how-can-i-easily-find-duplicate-records-my-database-and-then-remove-them

Links:
[1] http://www.lib.uts.edu.au/vote/node/5661/1/vote/utslibvote/MOQIaB_livbssopzg6LOdE9mAm6OJigMcEE-vD68VOk/nojs
[2] http://www.lib.uts.edu.au/help/referencing/refworks
[3] http://www.lib.uts.edu.au/question/5661/how-can-i-easily-find-duplicate-records-my-database-and-then-remove-them
[4] http://www.lib.uts.edu.au/node/5661/comments/newest
[5] http://www.lib.uts.edu.au/node/5661/comments/oldest
[6] http://www.lib.uts.edu.au/comment/172#comment-172
[7] http://www.lib.uts.edu.au/user/uts-library
[8] http://www.lib.uts.edu.au/vote/comment/172/1/vote/utslibvote/yVRxxwpHcUozLBbTRTf7MAlnargPJwhzL-dsRHO36O4/nojs
[9] http://www.lib.uts.edu.au/user/login?destination=node/5661%23comment-form
[10] http://www.lib.uts.edu.au/tag/refworks