Print

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

[Fred1]

filter Artists that contain semicola (";") for multiple artists?

Example: Bob Dylan; Joan Baez

I want to list all records that contain such multiple artists in the view pane.
[Artist]=";" or [Artist]="\;" (artist contains ";") doesn't work, however.

Thanks for your help!
Fred

[bMinor]

filter Artists that contain semicola (";") for multiple artists?

Example: Bob Dylan; Joan Baez

I want to list all records that contain such multiple artists in the view pane.
[Artist]=";" or [Artist]="\;" (artist contains ";") doesn't work, however.

type cmd+shift+F.
in the top left pop-up list select ‘artist’, in the top middle pop-up list select an expression such as ‘contains’, ‘is’ etc., in the top right pop-up list check all names you want to include.
apply. done.

[jbbernar]

This seems to work:

[=compare(listcount([Artist]), >, 1)]=1

But I would not be surprised if there were an easier way.

[Fred1]

type cmd+shift+F.
in the top left pop-up list select ‘artist’, in the top middle pop-up list select an expression such as ‘contains’, ‘is’ etc., in the top right pop-up list check all names you want to include.
apply. done.

bMinor, thanks, but that's not quite what i need.
I wanted to filter records that contain a ";" in the artist field.

Nevertheless, thanks for your answer!

[Fred1]

This seems to work:

[=compare(listcount([Artist]), >, 1)]=1

But I would not be surprised if there were an easier way.

jbbernar, that works as i wished!

Thank you for this expression. I wouldn't have thought of this myself.

Fred

[jbbernar]

It wasn't at all obvious to me, either! But I have a massive tagging project planned, so I've been looking for opportunities to play around with expressions.

[Fred1]

I'm retagging my huge library, too, and have relatively good success using regular expressions.

But one thing, i'm not able to do, is coloring the lines in the view pane depending on the type of file compression.
For example all MP3s should be blue, Flacs red and so on.

Do you have an idea how to achieve this?

[jbbernar]

This http://yabb.jriver.com/interact/index.php?topic=82496.0 suggested a method: add an expression column to your view, with something like this:

If(compare(listcount([Artist]), >, 1), <font color="ff0000">[Album]<//font>, [Album])

[Fred1]

jbbernar,

thanks again, your expression is working!
Only the expression column is colored, but that's good enough for me.

I still have to learn a lot, i think .