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.
Solved
Sorting tables with articles
Best answer by kuovonne
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+)", "")
+27Create 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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.