Now that [Artist] is a list type field, if you use [Artist] in any part of a rename expression, the output will use only the first artist in the list if there are more than one. I think this is appropriate default behaviour.
What I'd like to do is use an expression that will output the artists in full, ideally separated by a comma-space.
Eg. [Artist]=Barbra Streisand; Kris Kristofferson outputs to Barbra Streisand, Kris Kristofferson
The replace expression is easy enough, but the MC rename process is not passing the second artist instance through to the expression from what I can tell.
Eg. [Artist]=Barbra Streisand; Kris Kristofferson outputs to Barbra Streisand
I used to use a [Format Artist] calculated field to strip or replace characters unsupported by the windows file system. It also replaced ";" with "," for the purposes of renaming the files (could probably be simpler with Regex, I know!):
replace(replace(replace(replace(replace(replace(replace([Artist],Multiple Artists,Various),?,),:,/,),//,-),",’),*,●),;,/,)
This expression still works fine within the program (eg pasting into another field, or just by viewing the [Format Artist] field in any column or view).
Eg. Barbra Streisand; Kris Kristofferson > Barbra Streisand, Kris Kristofferson
I seem to be hitting a wall, however, when I want to use it in rename expressions.
Any ideas (apart from deleting that particular album from my library
)?