Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Alphabetizing / excluding the word "the"

Topic Labels: Formulas
Solved
Jump to Solution
345 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

1 Reply 1

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.