Help

Sorting tables with articles

Solved
Jump to Solution
677 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+)", "")