Help

Re: Alphabetizing / excluding the word "the"

Solved
Jump to Solution
960 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dani_Oliver
6 - Interface Innovator
6 - Interface Innovator

Hey there. I’d like to alphabetize one set of records in a table but would like to write a formula that would exclude the word “the” at the beginning when alphabetizing. (I rather not just format as Title, The.) Any possible way to do this, or no, because this is essentially a sorting issue, not a formula/record-naming issue?

1 Solution

Accepted Solutions
Nick_Dennis
7 - App Architect
7 - App Architect

The way you are describing, with a formula to strip “The” from the beginning, should work well. The formula would look something like SUBSTITUTE({Book Title}, "The ", "")

Note the capitalization and space after "The ". This should help ensure it only removes capitalized versions of the word (although it doesn’t really matter since it’s a hidden field), and the space makes sure it doesn’t leave an empty space at the start of the string after removing the word.

Then you would just sort your table by this new field, and then you can hide it if you want. The original Book Title field should still be your primary (first) field.

See Solution in Thread

2 Replies 2
Nick_Dennis
7 - App Architect
7 - App Architect

The way you are describing, with a formula to strip “The” from the beginning, should work well. The formula would look something like SUBSTITUTE({Book Title}, "The ", "")

Note the capitalization and space after "The ". This should help ensure it only removes capitalized versions of the word (although it doesn’t really matter since it’s a hidden field), and the space makes sure it doesn’t leave an empty space at the start of the string after removing the word.

Then you would just sort your table by this new field, and then you can hide it if you want. The original Book Title field should still be your primary (first) field.

How would you write this formula to work to exclude two articles? For example, excluding "The" and "A" from records when sorting alphabetically.