Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[jctcom]

hey all.

I just noticed that there does not seem to be any Sort fields in MC?  Is this normal?

I can create them but I am wondering why the omission?

I think I saw somewhere the option to ignore the "The, A," etc fields but this does not seem to help with my "The Alan Parsons Project".

Also I am wondering how it will handle the "Rename / Move" functions without this field?  I never want any folder or file to start with "The" or "A".

Also as long as I am going to create these fields I would like them to be automatic.  Can anyone give me the "Expression" syntax for Changing a field from "The ....." or "A ..." to "...., The" and "...., A"?

(I am sure I will learn the expression things eventually with few examples.  But I am only two days into this and am more interested in getting the software to work the way I like first lol.)

Thanks.  Much appreciated.


Thanks again.

Carl.

[6233638]

Tools > Options > Tree & View > Sorting > Ignore Articles will have sort behave the way you want.
Tools > Library Tools > Clean File Properties has the option to move articles to the end.

Unfortunately, I don't know that there is an expression to move articles to the end - at least I'm not seeing it in the documentation.

=Clean([Artist],1) will remove the articles, but doesn't move them to the end.

[jctcom]

Well that should be good enough for a sort field.  It's not like it actually needs the articles to sort by.

Thanks for your help.  I will give those a try.

Funny thing is.  I am sure I did the first option.  and my "The Alan Parsons Project" is still showing up as "The Alan Parsons Project".

I will have to check it again.

Carl.

[MrC]

In case you want to move articles, for example, in the Name field:

   if(regex([name], /#(The|A|El) +(.*)$#/), [R2]/, [R1], [Name])

Add more of your own, each separated by a vertical bar.

Assign to the Name field via:

   =if(regex([name], /#(The|A|El) +(.*)$#/), [R2]/, [R1], [Name])

[jctcom]

In case you want to move articles, for example, in the Name field:

   if(regex([name], /#(The|A|El) +(.*)$#/), [R2]/, [R1], [Name])

Add more of your own, each separated by a vertical bar.

Thanks.  I will try that out.  I guess if I wanted this for "Artist" and "Album Artist" I would just put those fields in place of "Name"?

Carl.

[MrC]

Right.  Add see my last line edit above to assign to the field.

[jctcom]

Actually I think what I want to do is to create my 2 new fields  "ARTISTSORT" and "ALBUMARTISTSORT" and have them calculate the sort field automatically and be un-editable.  (At least that's the plan).

I still like to see the full name in the display.  (Actually in the case of "The Alan Parsons Project" and other "Alan Parsons" related derivatives I am just going to change the "Album Artist" to "Alan Parsons" so I can get all of his albums in one place.

But for other artists it will be nice to have it available for the move and rename functions.

Carl.

[jctcom]

That worked out great!

Thank you very much.

Carl.