Defining a Complex Sort (by stripping out a pre-defined set of words) with Views I'd like to do a more complex sorting on my Drupal 7 View. Specifically, I'd like to sort by a particular field alphabetically (easy - that's the default). However, before the View sorts the field I want it to strip out (a predefined) set of words at the beginning of the field (if they exist) such as the word 'the' or 'a' and sort based on the words that follow.

Does anyone know if this is possible?

My workaround will be to just create a 'sort by' field in the content type.
Have you tried Views Natural Sort -module?


  Provides a views filter that sorts node titles by a more natural manner by ignoring articles like "The" and "A."


Not sure if it matches your needs because of "sorts node titles" and in your question you talk about particular field. But maybe you should try it?

At least you can get base for custom module if you need to build one.