Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Sorting tables with articles

Solved
Jump to Solution
1147 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ian_james_Dunca
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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