asked on FM - Sorting Titles
This is easy enough, but is there a standard way of creating a sort field for Titles. It seems it would involve accounting for "The", "A", and "An" beginning the title and placing it at the end using the Left and Middle functions, but wanted to make sure I wasn't missing anything. Thanks.
FileMaker Pro
Last Comment
rvfowler2
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Yes, I did leave that out, good catch.
willmcn's calculation will do what you want. However, here's a small point: Don't make the sort field a calculation field: instead, make it a text field, then add willmcn's expression as an initial calculated value. This permits you to override that field manually for rare cases where you want to strip something other than one of the three articles. For example, you may want to sort "Das Kapital" under "K" instead of "D", or a title such as "... and the Band Played On" under either "a" or "B", but not under "...".
Just a thought.
Just a thought.
ASKER
Thanks.