I would be interested if anyone comes up with an expression or other automated way to do this consistently and reliably ([edit] based on last name, first name)
I started out this way but decided there were too many exceptions to make it work properly, at least, I couldnt get it to work.Not sure how foobar or others achieve this or close to it ?
As I was having to make decisions about " should the bee gees be called gees, the bee or bee gees,the" or "Joe Cocker and friends" ,I guessed it would be impossible for a machine to decide.
I did my artist tagging manually in a non standard way which works well for me and MC sorts accordingly. I realize this is not a viable option for impoting 50,000 albums. If, however, you already have your external folder structure manually well organised MC may possibly parse the file and fill the tags from the file path.Others would need to advice on using custom expressions on import or just try selcting a few files and r click> library tools > fill properties from filename
Once tagged correctly, as you know, getting tracks to reference two or more artists is easy.