Sorting tables with articles


Is there a way to sort tables and ignore articles? For example, if we are using a big list of movie or book titles with the words THE, AN, A before the title.

Create a formula field that trims those initial words, and then sort on the formula field.

REGEX_REPLACE({Title}, "(?i)^(the\\s+|a\\s+|an\\s+)", "")

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.