4 Replies Latest reply on Oct 22, 2011 3:18 AM by Jonna

    How to do a sort based on the first letter of a field data?

    Jonna

      Title

      How to do a sort based on the first letter of a field data?

      Post

      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?

      Thank You,

      Jonna