Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Sorting tables with articles

Solved
Jump to Solution
298 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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