INTERACT FORUM

More => Old Versions => Media Center 16 (Development Ended) => Topic started by: trentino on May 21, 2011, 08:31:43 am

Title: How can I find files that ARE NOT duplicates
Post by: trentino 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?

Title: Re: How can I find files that ARE NOT duplicates
Post by: 221bBS 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"

Title: Re: How can I find files that ARE NOT duplicates
Post by: trentino on May 21, 2011, 11:05:39 am

Good thinking!  I will try that, thanks very much.