Multi-value field w/ duplicated value, any way to show it only 1 time?, [was “Multivalue fields with same value question”/TOS #6] Options

[silkcut]

Hello. Does anyone know how to compare values in multivalue fields and if they are the same then just display the value once?

e.g. say my PUBLISHER tag has Sire;Sire;Sire (It's stupid I know but I use Discogs Tagger and Discogs has multiple values for record labels even if it is the same record label.) , how can I have foobar2000 test for this and only display Sire?

Right now in my SimPlaylist grouping I have:

CODE

[$crlf()$replace(>>$meta_sep(PUBLISHER,' / ') ,', ',$crlf()>>)]

which inserts a "/" in between the values if they are different. e.g. "Sire / Mute" if PUBLISHER field is "Sire; Mute". But it still shows "Sire / Sire / Sire" when I would like it to just show "Sire".

Thanks!!

[BenB]

Try this:

CODE

$if($and($greater($meta_num(publisher),1),$strcmp($meta(publisher,1),$meta(publisher,2))),
$meta(publisher,1),
$meta_sep(publisher,' / '))

It checks to see if there are multiple values and the first and second values match. If they do, it returns only the first value. Otherwise it returns all values (including a tag with a single value).

I'll let you figure out how to incorporate it into your existing title formatting. I'd fix the duplicate tags if I were you.

This post has been edited by BenB: Feb 3 2013, 00:36

[BenB]

Scratch that title formatting. It should be:

CODE

$if($and($greater($meta_num(publisher),1),$strcmp($meta(publisher,0),$meta(publisher,1))),
$meta(publisher,0),
$meta_sep(publisher,' / '))

Ugh. I can't believe I forgot the enumeration begins with 0.

[silkcut]

Thanks. This will help.

Yes I think I will fix the tags instead. Is there a command that will remove duplicate values? i.e. %PUBLISHER% "Sire;Sire;Sire" ----> "Sire"

[BenB]

No, there is nothing I'm aware of that will remove duplicates for you.

The script I gave you is based on the assumption that if the 1st and 2nd values match (a=b), then the 1st and 3rd values also match (a=c), thus all three values match (a=b=c). If this is always true then the script can be modified to this:

CODE

$if($and($greater($meta_num(publisher),1),$strcmp($meta(publisher,0),$meta(publisher,1))),$meta(publisher,0),$meta(publisher,0)[; $meta(publisher,1)[; $meta(publisher,2)]])

for use with "Format from other fields" in the Properties dialog. It also assumes that the tag will never have more than 3 values.

On the other hand, if there are other scenarios, such as:

CODE

a=b,a≠c
a≠b,a=c
a≠b,a≠c,b=c

then the script will have to be modified to take them into account to remove duplicates.

This post has been edited by BenB: Feb 8 2013, 18:04

[silkcut]

Great. Thanks so much for your help!

[BenB]

You're welcome. I'm glad it worked for you.

I went ahead and wrote a script for use with "Format from other fields" that takes the scenarios into account I mentioned in my last post. Another difference is that it takes tags having more than 3 values into account and leaves them unchanged. I wasn't going to post it unless you couldn't use that last script I gave, but I'll post it anyway. I could probably tidy it up a bit using variable operations but meh.

CODE

$ifequal($meta_num(publisher),3,$if($and($not($strcmp($meta(publisher,0),$meta(publisher,1))),$not($strcmp($meta(publisher,0),$meta(publisher,2))),$not($strcmp($meta(publisher,1),$meta(publisher,2)))),$meta_sep(publisher,'; '),$if($not($strcmp($meta(publisher,0),$meta(publisher,1))),$meta(publisher,0); $meta(publisher,1),$if($not($strcmp($meta(publisher,0),$meta(publisher,2))),$meta(publisher,0); $meta(publisher,2),$meta(publisher,0)))),$ifequal($meta_num(publisher),2,$if($not($strcmp($meta(publisher,0),$meta(publisher,1))),$meta(publisher,0); $meta(publisher,1),$meta(publisher,0)),[$meta_sep(publisher,'; ')]))

This post has been edited by BenB: Feb 11 2013, 00:08