Print

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

[jctcom]

Hey I know this is probably pretty simple for the expression gurus out there.  But Me not programmer (I don't even like doing my accounting!)  hehe.

But I need one of two things please.

Either I need an expression that will take an existing field like [Name] and in the rename / move area automatically use the "Sorted" version of that name for the move So "The Gunman" becomes "Gunman, The" for the file name.

Or

I would create a new field [Name Sorted] and the data would automatically be pulled from the existing one [Name] and be correctly renamed as the sort field.

Much thanks in advance.

Carl

[blgentry]

This expression will transform "The Artist" into "Artist, The".  It outputs NOTHING if the artist doesn't start with The.

Code: [Select]

=if(Regex([Artist],/#^(The)\s+(.+)#/, 0,0),[R2]/, [R1],)
You could easily modify it to output the Artist field if there is no "the".  This expression WILL NOT WORK in the Rename, Move, and Copy tool.  You'll need to use this expression to create a new field, as you described, and  then use that field name in the RM&C tool.

Please do some experiments first, use the preview window, and generally be really careful.  Good luck!

Brian.

[jctcom]

Thanks Brian.

How would I add the other Articles to that like "A", "An", "La", "Le" etc...

Basically I want to create a sort field for Movie and TV Series  (I'm surprised it doesn't already exist?  Or am I just not seeing it somewhere?)

Thanks again.

Carl.

[blgentry]

MC is supposed to be able to sort and ignore any kind of article.  (A, The ,etc)  I was going to mention this, but you said you wanted to use Rename, so I went with it.

If you're just trying to sort and ignore articles, set the option! 

Tools > Options > Tree & View > Sorting > Ignore Articles > (checked)

If you still need help past that, I'll see what I can do.

Brian.

[jctcom]

I do already have that set.

But as you said this is for the purpose of creating a Rename / Move expression.  If I use the [Name] field in a Rename / Move expression it does not create the folder / file names with the correct sort option(S).

Carl.

[blgentry]

Ok, here's how you modify the expression.  Take this middle part here:

#^(The)\s+(.+)#/

...and add "or" conditions like:

#^(The|A)\s+(.+)#/

A "|" character (pipe or vertical bar, NOT an l) means "or".  You can add more so:

#^(The|A|Le)\s+(.+)#/

That should work, but please test it.  Good luck!

Brian.

[jctcom]

Thanks a lot.

I just realized during our conversation that I had created a similar expression for sorting Artists (With the help of the forum of course).

So I just took that and substituted [Name] for [Artist].

appreciate your break down though.  Creates some actual comprehension.  lol

Carl.