# Thread: The, An, A in titles

1. ## The, An, A in titles

We know that when we alphabetize titles, the articles The, An, and A need to come at the end preceeded by a comma. "Ash Grove, The" not "The Ash Grove"
Thanks to Cal Locklin, I found a formula to make this work. In the record, store the title as written, "The Ash Grove" and then use the following formula in your order expression and as a calculated field for display. The title will appear in the proper order and display as "Ash Grove, The"

IF( WORD(Title,1)='The' ,alltrim(SUBSTR(Title, at(" ",Title) + 1) )+", "+word(Title,1),if(word(Title,1)='An',alltrim(substr( Title,at(" ",Title)+1) )+", "+word(Title,1),if(word(Title,1)='A',alltrim(substr(Title,at(" ",Title)+1))+", "+word(Title,1),Title)))

Thanks again to Cal

Jim

2. ## RE: The, An, A in titles

James,

Rather than repeat the return expression thrice, you could use a much shorter expression:

if(*word("THE AN A",upper(word(Title,1))),alltrim(SUBSTR(Title, at(" ",Title) + 1) )+", "+word(Title,1),Title)

My 2 cents,
Steve

3. ## RE: The, An, A in titles

Very interesting. I really don't understand the formula. I'll try to study it and break it apart so that I can understand it.

Thanks
Jim

4. ## RE: The, An, A in titles

Steve/James, et al,

I like this function. But I also need to include many other articles, including foreign articles. I simply replaced the hard-coded article list with a variable called ARTICLES and then used another window to allow the user to enter additional articles which were then added to the list. This will be great for my database of Senior Theses at my college, where thesis are written in many different languages.

Stephen Pilon

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•