I am using the Sort feature in JMP17.0.0 but am getting unexpected results. The column I wish to sort by contains a list of serial numbers where each is a mix of letter and numeric characters (examples: G95VXWW8CID5, G921J8D2CIE3, G943H085CIB2). The Sort-> Ascending action puts G95... ahead of G92... which is ahead of G94... This is unexpected because while the first two characters in all three serial numbers are the same, G9, in the third position, 2 should be before 4 which should be before 5. What are the rules by which JMP sorts alphanumeric values, and can those rules be edited?
