rvfowler2
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.