Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[HiFiTubes]

Hi all,

I'm always talking up MC (as many of us long-time users tend to do), and though I inevitably mention the power of the expressions, I'm not an expert.

How can I isolate a bunch of dups that were made such as:

xxxxxxxxx-The Best Of Albert King\Albert King - The Best Of Albert King (1986) - 03 - Honky Tonk Woman (1).flac

I've got a good dups view setup but it doesn't' split these out into a separate Grouping due to file name.

[HiFiTubes]

For example, even using a custom view just for this I can't get it right.

[HiFiTubes]

Derrrr...I nixed the bottom filter and looks like it's working!

[HiFiTubes]

And so, my final question would be:

Can MC be smart enough to tell me if any of these generic results contain instances which are not dups (i.e the (1).xxxx files are the only copy in database).

[MrC]

You can create an expression that will take the results you have, your files ending with (#), and have it indicate if the same named-files sans the (#) segment exist on disk.  Is that what you are looking for?

[HiFiTubes]

You can create an expression that will take the results you have, your files ending with (#), and have it indicate if the same named-files sans the (#) segment exist on disk.  Is that what you are looking for?

Yes, so far I am just checking manually looking on Disk Externally.

[MrC]

Here's a view that will help you out.  See attached.

The Base name, Missing? and Dup status columns are defined with the following expressions:

Base name:
   regex([Filename (name)], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]

Missing?
   ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2])

Dup status:
   if(ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]), No Dup, Possible Dup)

[HiFiTubes]

Nice, many thanks!

While I have your attention, one other thing I'm after is a more intelligent Duplicates View.

I can bring up a view which contains a basic display of files that are Dups of Name/Duration and maybe Sort by Album, but the results are only one set, the Dups.

What if I want to display Albums in a Grouping so I can determine which to delete: FLAC vs. MP3?

I can start a new thread...been playing around with many 'basic' ways to do this and so far nothing feeling right.

[MrC]

A couple of questions...

1) are you possible dups in the same folder?
2) do the possible dups have exactly the same base name as the MC-imported file?

The trick we're using is to use the file name from the MC database, make some minor alteration (such as removing the (#) segment) and looking for that other file on disk.

[HiFiTubes]

EITHER:

Missing?
   ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2])

Dup status:
   if(ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]), No Dup, Possible Dup)


hangs and crashes MC18 for me, sorry.

Here's a view that will help you out.  See attached.



The Base name, Missing? and Dup status columns are defined with the following expressions:

Base name:
   regex([Filename (name)], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]

Missing?
   ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2])

Dup status:
   if(ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]), No Dup, Possible Dup)

[HiFiTubes]

A couple of questions...

1) are you possible dups in the same folder?
2) do the possible dups have exactly the same base name as the MC-imported file?

The trick we're using is to use the file name from the MC database, make some minor alteration (such as removing the (#) segment) and looking for that other file on disk.

I don't think I have many (#) dups left; mainly I now have:

1. dups of albums with various file types and bitrate - I'd like a way to see these easily enough in a way to compare quickly and delete some (sometimes I want to save different release and quality so as to demo mp3 vs. 96kHz vs. DSD)

2. dups with exact same name and duration; the same file twice where one can be safely deleted.

[MrC]

EITHER:

Missing?
   ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2])

Dup status:
   if(ismissing(regex([Filename], /#^(.*?) \(\d+\)(\..*)$#/, -1)[R1][R2]), No Dup, Possible Dup)


hangs and crashes MC18 for me, sorry.

The ismissing() function is checking for files on disk, so it will be slow (so be patient).  The Set rules for file display is helpful to prevent excessive disk checks.

If this is crashing MC, it would be worth asking Matt if he'd like a log.

[MrC]

I don't think I have many (#) dups left; mainly I now have:

1. dups of albums with various file types and bitrate - I'd like a way to see these easily enough in a way to compare quickly and delete some (sometimes I want to save different release and quality so as to demo mp3 vs. 96kHz vs. DSD)

2. dups with exact same name and duration; the same file twice where one can be safely deleted.

For (1), you'll want to have the files imported in MC and create probably an album-based panes view, that shows the variations as columns so you can select one or the other.  Perhaps the leftmost column could be a calculated count of the number of [track #].[disc #] where the resulting value is 1. or 1.1 (in other words, if you have more than one of these, then you must have two or more albums).  Ask if you need help doing this...

For (2), this seems like a basic dups smartlist, looking for dups of [name],[duration].