I appreciate your help. In your example Pirates should not be displayed because there is no actual double other than the acoustic one. And imo it doesn't count as a double.ZvezdanD wrote: Your description is not precise. What if you have just two songs: 'Pirates' and 'Pirates (No Vox)', should 'Pirates' be displayed in that case or not?
Your mask doesn't work when i enter it in magicNodes it says 'invalid mask'.
Good idea i will do thatZvezdanD wrote:My advice is to use "[ ]" only for the version information and "( )" for the actual part of Title. In that case you will be sure that any manipulation with "[ ]" would include only the version information, not the part of Title. You could use RegExp Find & Replace add-on and its "Replace (... remix/version/edit ...) with [ ... ] at the end of <Into Field>..." preset for that.
Edit: i have this now
Code: Select all
Songs.Custom1 IN (SELECT Custom1 FROM Songs WHERE Length(Custom1) > 0 GROUP BY Custom1 HAVING Count(DISTINCT Artist) > 1) AND (<Title> Not Like '%(%' OR <Title> Not Like '%[%')It still shows tracks with '(' and ')' though...