INTERACT FORUM

Please login or register.

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

Author Topic: Sort Multiple-values field  (Read 1505 times)

vkostas

  • Recent member
  • *
  • Posts: 10
Sort Multiple-values field
« on: August 24, 2008, 04:37:17 am »

Hello,

I found from some post that standard tags like [Artist], [Genre], [Composer], etc are not multiple-values compatible (on purpose).
That's a solution for this. Create a new field [Artists] which will be automatically calculated through formula
Code: [Select]
[Artist]&DataType=[List](I found this from some post too). This way no (real) mp3 tag is needed in mp3 file. So far so good.
I want to go one step further: SORTING. E.g. Eric Clapton should be listed under C (Clapton, Eric), The Eagles under E (Eagles, The).

1. Function Clean([Artists],2) can be used to remove Prefixes (A, An, The). But this is working only for the 1st artist. E.g. (just for testing) "The Eagles;The Beatles" will be converted to "Eagles;The Beatles". Even though other articles might be requested (In, On, At, etc). Is there any way to apply Clean() to each value of a [Artists]? Would it help if all articles are entered in a new [Articles] field separated by semicolon?

2. How to sort (multiple) artist names (Bryan Adams;Sting;Rod Stewart -> Adams, Bryan;Sting;Stewart, Rod) without maintaining a separate tag?

Thank you.
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Sort Multiple-values field
« Reply #1 on: August 24, 2008, 07:09:31 am »

Hello,

I found from some post that standard tags like [Artist], [Genre], [Composer], etc are not multiple-values compatible (on purpose).
That's a solution for this. Create a new field [Artists] which will be automatically calculated through formula
Code: [Select]
[Artist]&DataType=[List](I found this from some post too). This way no (real) mp3 tag is needed in mp3 file. So far so good.
I want to go one step further: SORTING. E.g. Eric Clapton should be listed under C (Clapton, Eric), The Eagles under E (Eagles, The).

1. Function Clean([Artists],2) can be used to remove Prefixes (A, An, The). But this is working only for the 1st artist. E.g. (just for testing) "The Eagles;The Beatles" will be converted to "Eagles;The Beatles". Even though other articles might be requested (In, On, At, etc). Is there any way to apply Clean() to each value of a [Artists]? Would it help if all articles are entered in a new [Articles] field separated by semicolon?


Thank you.

for this you could also check 'ignore articles (a, the, an)' under tools>options>tree and view> sorting. works only for american/english articles.

for 2, i think the only solution you have is to enter it yourself that way. i guess it would be impossible to know for mc where the last name starts.

 :)
gab
Logged
Pages: [1]   Go Up