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
[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.