This has to be covered somewhere, but I couldn't find it. I'm using FM9 and I want to sort a title field. I need to enter the title with the initial "The" "A" or "An" but I want the sort to ignore those. I want the title The Age of Anxiety to sort it as if it were Age of Anxiety.

Many people must have had this problem, but I can't figure out what to do. It's a shame FM doesn't have an automatic sort which will do this, but since it doesn't, can someone suggest how I can do it?

Thanks.

Mike

The solution is sorting by another ( calculated ) field, something like:

Case(

LeftWords ( Title ; 1 ) = "The"

or

LeftWords ( Title ; 1 ) = "A"

or

LeftWords ( Title ; 1 ) = "An" ; RightWords ( Title ; WordCount ( Title ) - 1 ) ;

Title

)

or simply, but with the same result:

Case(

ValueCount ( FilterValues ( LeftWords ( Title ; 1 ) ; "The¶A¶An" ) ) ; RightWords ( Title ; WordCount ( Title ) - 1 ) ;

Title

)

Daniele,

I finally got a chance to see your reply. I tried it out, and it worked perfectly.

Thanks very much for your help.

Mike Janus