Ok I am going to post this here in case anyone is interested for themselves. I have worked this out with a lot of help for Mrc and it works great.
First off what it does. it is a single expression that will rename and move (Depending on how you have your template(s) set up). Your files (Based on their tags) into a specific set of folders / File names. The trick was to get an expression that would work for standard single discs, Multiple discs and Vinyl in the single expression.
Here is the expression for the naming of the directories:
[ALBUMARTISTSORT]\{[Date]} [Album]Delimit([ALBUMSUBTITLE,0], /) , / /( )
Here is the expression for the files:
if(IsEmpty([VinylTrack#,0],0), If(IsEmpty([Disc #],1), [Track #], D[Disc #] - [Track #]), [VinylTrack#]) - [Name] - [Artist] - [Album]
A couple of things to note:
I have created the following fields myself as they did not exist in MC:
ALBUMARTISTSORT
ALBUMSUBTITLE (I use this for multiple versions of an album such as "24Bit/96KHz Vinyl", "Blu-Ray" "Special Edition" etc. etc
VinylTrack# (Not sure if these fields are case sensitive or not?)
You can of course make the fields whatever you want. I chose some of these names because they already existed in my files / tags from previous software.
For the ALBUMARTISTSORT I have created an expression (Again with MrC's or someone else's help here) that automatically generates and fills the field based on the "Album Artist" I will post that below for those that are interested with details on creating it.
A really interesting thing about this is that I can select a whole whack of files are are all different (Single disc, Multi-Disc, and Vinyl) and as long as they are tagged properly they will all end up in the right place with the correct naming convention (Well my correct naming convention anyways lol)
To automatically create and Album Artist Sort and an Artist sort here is what I did:
Go into Tools - Options - Library & Folders.
Click on "Manage Library Fields" (Hopefully if you are reading up to here you have already had a bit of experience with creating your own fields (By far one of the strongest aspects to MC as far as I am concerned)
For the purposes of this discussion I created an "ALBUMARTISTSORT" field and an "ARTISTSORT" field
When you create your field everything is pretty straight forward. Under the data field though you want to select "Calculated Data"
here is the expression for my "ALBUMARTISTSORT" field:
if(regex([Album Artist], /#(The|A|El) +(.*)$#/), [R2]/, [R1], [Album Artist])
btw I don't understand the majority of this expression. The only thing I know for sure is it takes the "The", "A" and "El" and places them at the end of the phrase after a comma and a space. Also if you have something else you would like to have moved in that way you can add it into the orange section with another "|" between them.
Same for "ARTISTSORT" just replace the appropriate fields
Again I did not come up with these expressions on my own (Or even mostly on my own!) I just thought I would post this here for any other newbies like myself wanting to get this kind of functionality out of MC.
Feel free to add or change anything you want to suit your needs (I know I do! I have already created fields for Track Subtitle, Disc Subtitle etc. for future plans!)
Again thank you very much to those that helped me achieve this. (You know who you are!) (He just read the earlier parts of the thread)
Hope this is useful to someone.
Have fun!
Carl. (My first foray into expressions!)