AnsweredAssumed Answered

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

Question asked by Jonna on Oct 21, 2011
Latest reply on Oct 22, 2011 by 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

 

Outcomes