Alphanumeric sorting rules in JMP17
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 thre...