You could use some snazzy SQL to help with that:
CASE WHEN Title LIKE 'The %' THEN SUBSTRING(Title,5,LEN(Title))+', The'
ELSE Title END AS TitleSort
Add this as a separate field, and include in list views and report. Is
reports, you would use it in the sorting formulas and in list views you
would place it after the title, hide it, and set the title to sort by the
next field.
Chad Petrovay *| *Project Manager
[log in to unmask] *|* 646.733.2239 x252
*GallerySystems | *www.gallerysystems.com
On Mon, Dec 15, 2014 at 2:09 PM, Morgan, Amber <[log in to unmask]> wrote:
>
> Just wondering how others are handling data entry for titles that begin
> with the word “the.” Our curators dislike how including “The” at the
> beginning interferes with alpha sort. But the idea of entering the titles
> inverted seems absurd to me. For example, a film called “The Chelsea
> Girls” will alpha sort under the letter T. Is there a way to get it to
> sort under the letter C without changing the title to “Chelsea Girls,
> The”? The only thing that comes to mind is creating a separate title type
> for alpha sort, sort of like the alpha sort field in constituents. But in
> order for it to work, we’d have to enter an alpha sort field for everything
> and build reports and views that display that field rather than the primary
> title. I’m sure that would work but we just don’t have time to do that
> kind of data entry. Anyone have any clever tricks for this?
>
>
> Thanks,
> Amber
>
>
>
> *the warhol**:*
> *Amber E. Morgan*
> Collections Manager
> 117 Sandusky Street
> Pittsburgh, PA 15212
> *T* 412.237.8306
> *F* 412.237.8340
> *E* [log in to unmask]
> *W* www.warhol.org
>
> *The Andy Warhol Museum*
> *One of the four Carnegie Museums of Pittsburgh*
>
> Email newsletter http://members.carnegiemuseums.org/email
> Membership http://members.carnegiemuseums.org/SupportCMP
>
> warhol: facebook <http://www.facebook.com/thewarholmuseum> | warhol:
> twitter <http://www.twitter.com/thewarholmuseum>
>
>
>
>
>
> The information contained in this message and/or attachments is intended
> only for the person or entity to which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance upon,
> this information by persons or entities other than the intended recipient
> is prohibited. If you received this in error, please contact the sender and
> delete the material from any system and destroy any copies. Any views
> expressed in this message are those of the individual sender.
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
