Check title includes mix

So I'm at the level that I'm pretty much finished with my music collection and am now de-duplicating it.

One of the issues I've run into, is that for some songs, they are

Artist - title

and there is a rag remix/mix or mixer with (Candlelight remix) in it for example

Other songs are artist title (remix)

how can I best align all these ?

The main issue is there are quite a few tracks where the file name shows it's a remix, but the meta data doesn't.

but some title have only the meta data / title correct so I don't want to overwrite those from the file name, as I'll lose the remix data.

Initial thoughts are to capture the filename title into another field and do it manually, but I know we have lots of really clever people in here who can probably come up with a better and more clever way to do it.

One way could be:

Load all your tracks into Mp3tag.
Sort them first by the column ARTIST.
Then sort them by the Column TITLE.

This should show you all the similar tracks for your case, grouped together with or without the 'remix' suffix.

Please show us a screenshot from some example filenames in your collection.

You can see here Young Diciples is missing the (edit) for the mix.

I've pulled that into the title-mix field for the basic compare.

The ones with mix, will have plain artist - title, but in the mix tag it would have (in this example (edit) or just edit.

The main problem in your case it that Mp3tag does not compare different tracks.
It only handles track by track, one after the other.

The only possibility I see is to fill your TITLE field again from your current filename.
For example with the Convert Filename - Tag and a Formatstring like
%ARTIST% - %TITLE% -%YEAR%

Or if you want to let ARTIST and YEAR untouched, only use
%dummy% - %TITLE% -%dummy%

You should immediately see in the preview, if the format string works as expected.


Just to be clear:
I would advise against using metadata or filenames to de-duplicate your music tracks.
There is absolutely no guarantee that
Young Disciples - Apparently Nothin' (Edit) -2015.mp3
really contains the edited version of that song.
Even if your filename or metadata tell you so.

Here is an example - track will have the DJB mix/remix (it's a shortened dj version)

image

Normally I agree in this case I'm ok, because for 99/100 it will be correct and for the one time it isn't I will hear it before I play it and I can fix it then.

This is what I've done.

Just need a way to flag/filter those tracks where title + mix field are different to title-mix field and that way I can fix 55k tracks.

Planning on this

"$if($eql(%title%,%title-mix%),1,0)" IS 1

If there isn't a better way.

That shows me where the title and file name differ

The problem I have is the alarm one, where the title is already correct. (so I need the filter to say is the title longer than title-mix

image

Something like this?
"$len(%title%)" GREATER "$len(%title-mix%)"

In my further tests and thanks to @ohrenkino I realized, that the above Filter doesn't work as expected.

Try
"$if($eql($len(%title%),$len(%title-mix%)),1,0)" IS "0"