Feb 04, 2022 07:55 AM
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! Go to Solution.
Feb 04, 2022 08:29 AM
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+)", "")
Feb 04, 2022 08:29 AM
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+)", "")