INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Making [Publisher] a list  (Read 1646 times)

Khaoz

  • Recent member
  • *
  • Posts: 12
Making [Publisher] a list
« 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
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Making [Publisher] a list
« Reply #1 on: January 28, 2012, 01:10:14 pm »

Add your values to Publisher, semicolon separated.

Then, use an expression column:

[Publisher]&datatype=[list]
Logged
The opinions I express represent my own folly.

Khaoz

  • Recent member
  • *
  • Posts: 12
Re: Making [Publisher] a list
« Reply #2 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. :)
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Making [Publisher] a list
« Reply #3 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 for more info about the MC expression language.
Logged
The opinions I express represent my own folly.

Khaoz

  • Recent member
  • *
  • Posts: 12
Re: Making [Publisher] a list
« Reply #4 on: January 28, 2012, 07:52:09 pm »

Thank you so much. I think this kind of language is very powerful!
Logged
Pages: [1]   Go Up