Hi i have output like the following
FI-7-M
FI-7-M
FI-7-M
FI-7-S
FI-7-C
FI-7-CAB
FI-7-A
FI-7-B
FI-26-M
FI-10-M
FI-1-A
AND SINCE NORMAL SORTING PRODUCES BAD RESULTS
FI-26-M
FI-7-A
AND SO ON (SIMPLY INSTEAD OF SORTING 1,2,3 I GET 1,10,2,20)
HOW DO YOU GO ABOUT SORTING SOMETHING LIKE I HAVE ABOVE IN A NORMAL ORDER EITHER DESC OR ASC?
FI-7-M
FI-7-M
FI-7-M
FI-7-S
FI-7-C
FI-7-CAB
FI-7-A
FI-7-B
FI-26-M
FI-10-M
FI-1-A
AND SINCE NORMAL SORTING PRODUCES BAD RESULTS
FI-26-M
FI-7-A
AND SO ON (SIMPLY INSTEAD OF SORTING 1,2,3 I GET 1,10,2,20)
HOW DO YOU GO ABOUT SORTING SOMETHING LIKE I HAVE ABOVE IN A NORMAL ORDER EITHER DESC OR ASC?