INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: How can I find files that ARE NOT duplicates  (Read 1454 times)

trentino

  • Regular Member
  • Recent member
  • *
  • Posts: 46
  • Change this by choosing profile
How can I find files that ARE NOT duplicates
« on: May 21, 2011, 08:31:43 am »

Somehow my music library is duplicated in the database -- all my music files appear both as E: (my backup drive) and T: (my main drive). 

I'm just going to delete all the E: entries from the database...  BUT I see that there are 131 more files in E: that aren't in T: ... 

How can I make a list of what these 131 unique files are?
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: How can I find files that ARE NOT duplicates
« Reply #1 on: May 21, 2011, 10:15:05 am »

If the only thing that is different is the drive letter, I would do the following.

Create a new field named "TEMP" (DO NOT check the store in tag option).
Add the "TEMP" field to the column list.
Open the Action Window > Tag
Select the files you want to check and type the following in the "TEMP" field
Code: [Select]
=RemoveLeft([Filename],3)Click the drop down arrow in the search window and click "Wizard..."
Under Modify Rules select "Remove duplicates of" in the first box and "TEMP" in the second.
Press "OK"
Logged

trentino

  • Regular Member
  • Recent member
  • *
  • Posts: 46
  • Change this by choosing profile
Re: How can I find files that ARE NOT duplicates
« Reply #2 on: May 21, 2011, 11:05:39 am »

Good thinking!  I will try that, thanks very much.
Logged
Pages: [1]   Go Up