Topic: expression help please: find all files with more than 1 artist (Read 346 times)

comox · « **on:** August 01, 2023, 11:02:26 am »

Could someone please show me how to find all files that have more than 1 semicolon delimited artists?

Thanks.

Matt · « **Reply #1 on:** August 01, 2023, 11:06:41 am »

This might be a start:
ListCount([Artist], /;)

lepa · « **Reply #2 on:** August 01, 2023, 11:12:03 am »

e.g. insert this to search when in your view
[=Compare(ListCount([Artist]),>,1)]=1

Compare inside square brackets checks if there is more than one artist and it returns 1 if true so 1=1 when song has more than one artist and is therefore displayed with this filter.
If there is only one or less artist then compare returns 0 so 0=1 is not true so these songs are filtered out

comox · « **Reply #3 on:** August 01, 2023, 11:59:36 am »

Works perfectly. Thanks to both of you!

I thought I'd get clever and add the name of artists that appear in more than one band. For example:
Eric Clapton
Blind Faith; Eric Clapton
Derek and the Dominos; Eric Clapton

But this messed up the app I use to play music on my phone. So I have to go back and fill in [Album Artist] with the single name of the band.

INTERACT FORUM

Author Topic: expression help please: find all files with more than 1 artist (Read 346 times)

comox

expression help please: find all files with more than 1 artist

Matt

Re: expression help please: find all files with more than 1 artist

lepa

Re: expression help please: find all files with more than 1 artist

comox

Re: expression help please: find all files with more than 1 artist