Defining a Complex Sort (by stripping out a pre-defined set of words) with Views
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.