2 Replies Latest reply on Oct 23, 2010 9:27 AM by sburech

    Sorting Radio Call Signs



      Sorting Radio Call Signs


      I am a amateur radio operator.  I created a database of all the other operators I have had conversations with.  The call signs have one number preceded and followed by one or more letters.  Examples: KA8VAL, K2AN, N7CGE, KB6TQ, KA8NXV.  I would like to sort first by the number, which indicates the region of the station and finally by the letters following the number.  In the examples above, the sorting would be: K2AN, KB6TQ, N7CGE, KA8NXV, KA8VAL.  If a script is the way to go, please give me the code.  I am using FM-11 with a MAC running OS 10.5.8.  Thanks for your assistance.

        • 1. Re: Sorting Radio Call Signs

          If you create two calculation fields that parse out the number and text portions you need for sorting you can get the sort order you want by sorting on those two calculation fields.

          Let's assume your call signs are entered into a text field named CallSign. Define the first field, cSort1, as simply CallSign but set its return value to number--not text. Sorting on this field will sort them by the number portion of the call sign.

          Define a second field, cSort2, to parse out only the text to the right of the last numerical digit in the call sign:

          RightWords ( Substitute(CallSign ; [0 ; " "] ; [1 ; " "] ; [2 ; " "] ; [3 ; " "] ; [4 ; " "] ; [5 ; " "] ; [6 ; " "] ; [7 ; " "] ; [8 ; " "] ; [9 ; " "] ) ; 1 )

          Now, if you specify cSort1, then cSort2 in your sort order, you should get the order you've specified.

          • 2. Re: Sorting Radio Call Signs

            Thank you very much!