INTERACT FORUM

More => Old Versions => Media Jukebox => Topic started by: Khaoz on January 28, 2012, 12:06:49 pm

Title: Making [Publisher] a list
Post by: Khaoz on January 28, 2012, 12:06:49 pm

Hi! It's my first day working with the software (fits perfectly what I wanted BTW), but I find that a lot of records are published by two or more companies at the same time. I want to know if there's a way to make [publisher] work as a list instead of as a string. I assume it's impossible, so what magical formula I can put in an expression column to have it done?

It would be the cherry on top of my music library :P

Title: Re: Making [Publisher] a list
Post by: MrC on January 28, 2012, 01:10:14 pm

Add your values to Publisher, semicolon separated.

Then, use an expression column:

[Publisher]&datatype=[list]

Title: Re: Making [Publisher] a list
Post by: Khaoz on January 28, 2012, 01:51:14 pm

Thank you, it works perfect, but I'd like to know if it's possible to use different separators (i.g. / or -). Not a big deal, it's just that I find ; ugly as hell. :)

Title: Re: Making [Publisher] a list
Post by: MrC on January 28, 2012, 06:20:35 pm

You can.  You'll have to process them using a Replace() function, since MC uses semicolon internally to separate elements.  So, place what you want in your tags, and use the expression language to break items apart for MC lists.

Eg:

  Replace([Publisher], //, ;)&datatype=[list]

This replaces forward slash with semicolon (note the double slash here, as MC uses slash as the quote character).

btw. try replacing with a backslash for a nested tree!

See: http://wiki.jriver.com/index.php/Media_Center_expression_language (http://wiki.jriver.com/index.php/Media_Center_expression_language) for more info about the MC expression language.

Title: Re: Making [Publisher] a list
Post by: Khaoz on January 28, 2012, 07:52:09 pm

Thank you so much. I think this kind of language is very powerful!