Sort fields smallest to largest
Our unit field on the address is a text field as we have numeric values (ex. 101, 102) and text values (ex. main, lobby) in this field. Therefore, in a scenario where I am trying to sort a townhouse complex with unit numbers 1-40, I get 1, 10, 11....19, 2, 20..etc. It would be helpful if we could sort text fields smallest to largest where numbers are sorted in correct numerical order with alpha characters sorted in alphabetic order after the largest number (ex. 1,2,3....9,10,11...99, 100, lobby, main).
4
votes
