Skip to main content

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.

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

Reply