On Oct 24, 2006, at 5:00 PM, Colin Scarrott wrote:
Thanks for that, I now know how it sorts, just got to figure a work
around now for my problem.
All the best
Colin
No
It's sorted like a dictionary and NOT numerically
Since the "letters" 0,1,2,3,4,5,6,7,8,9 sort in that order NCP0
comes before NCP1 AND NCP100 comes before anything with NCP2
Here's what I'm now using (theStatus is a String array containing the
returned values):
If Left(theStatus(x), 1) = "S" Then
// Slot - S13:A00342L3 or S13:
Slot = NthField(theStatus(x), ": ", 1)
Content = NthField(theStatus(x), ": ", 2)
// There could be over 5000 entries, so pad to 4 zeros
Slot = Format(Val(Right(Slot, Len(Slot) - 1)), "0000")
Slot = "S" + Slot
If Content = "" Then
Content = kNoBarcode
End If
theStatus(x) = Slot + ":" + Content
ElseIf ...
// also do this for C, D, and I values
...
End If
theStatus.Sort
HTH,
Tim
--
Tim Jones [EMAIL PROTECTED]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
