How to do a sort based on the first letter of a field data?
I have a simple FM file, because I'm a simple person.
I would like to sort all my records in that file based on a field (named "route") which has simple data in each record: "N122", "S243", "K457", etc, a letter followed by three numbers. I need to do a sort based on the first letter only, and then a secondary sort on another, a number field. How can I extract the first letter to do a sort on that value only?