AnsweredAssumed Answered

FMP 12 Sort Function

Question asked by RishiTrikha on Feb 5, 2014
Latest reply on Feb 5, 2014 by philmodjunk

Title

FMP 12 Sort Function

Your post

     I have a question about the sort function. I have my key field as and ID number as a number field. However, the ID number can also contain a letter, for example E3 or B79. So if I have a data set {14, 1, B1, 2, 5, 23, 109, B4, PRECISE 1}, and I try to sort ascendingly it will sort as {PRECISE 1, 1, B1, 2, B4, 5, 14, 23, 109}, however I would like it to sort as {1, 2, 5, 14, 23, 109, B1, B4, PRECISE 1} or {1, 2, 5, 14, 23, 109, PRECISE 1, B1, B4}, how can I make this happen.

     Best,

     Rishi

Outcomes