See attached file. How do I sort by the Bin number in an ascending order. Thank You!
Sort Records by Field
manually or Sort script step:
(and follow the links, especially:
Options for sorting records)
Since the bin numbers are actually text (because of the "-" in them), you will have to create 2 calculation fields c.aisle and c.bin and parse out the aisle number and bin number to sort them as if they were numbers:
c.aisle = Left(Bin; Position(Bin;"-";1;1)-1)
c.bin = Right(Bin; Length(Bin) - Position(Bin;"-";1;1)
Then sort first by c.aisle and then by c.bin
In addition, it has "A" suffix in sum records. Aren't there any other alphabets?
How do you want to sort it? It may be able many choices. ignore, ascending/descending each with nulls(without alphabets) first/last
Retrieving data ...