Terminal-digit order
Posted by Kevin on September 04, 2001 9:05 AM
How do I place a long list of file numbers in terminal digit order using the last 6 digits; In other words, sort first by the last two digits (terminal), then by the two digits before the last two, then finally by the two digits before them.
55500000000
55500000001
55500000101
55500010101
55500100101
My guess is to start, you need three columns for the three sets of two digits. Thanks.
Posted by Mark W. on September 04, 2001 9:10 AM
Parse the values that you want to sort on to
separate columns using the Text to Columns...
menu command and then sort on the values in
the new columns.
