Sort by collapsed fields

[Ian_james_Dunca]

Hello!

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.

[kuovonne · Accepted solution]

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+)", "")