Say I have the following data: +-------------------------------------------------------------------------------+ | title | +-------------------------------------------------------------------------------+ | ...And justice for all | | 12 Angry Men | | The Abe Lincoln of 9th Avenue | | A Cry for Freedom | | Alice in Wonderland | +-------------------------------------------------------------------------------+
And I want to sort it alphabetically, but with the numbers spelled out and the leading articles removed. I know I can use trim to get rid of the leading A/An/The/... but I want to sort 12 in the Ts for twelve, like this: +-------------------------------------------------------------------------------+ | title | +-------------------------------------------------------------------------------+ | The Abe Lincoln of 9th Avenue | | Alice in Wonderland | | ...And justice for all | | A Cry for Freedom | | 12 Angry Men | +-------------------------------------------------------------------------------+ So it is alphabetized by "Abe", "Alice", "And", "Cry", and "12" as twelve. Any ideas, or should I just tell the user to spell out numbers? Thanks!
