I have pulled numbers like these from a table and it sorts them 1,10,11... I want them 1,2,3....and so on.
Good example
250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01
250-HP-1401 CCT2: IN-250-PW-4020-04
Bad example
250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01
250-HP-1401 CCT10: SPARE
I have extracted the singular number from the rest of the sting hoping i could just low to high sorted them and all would fall in place. but im coming up with a invalid procedure call?
Good example
250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01
250-HP-1401 CCT2: IN-250-PW-4020-04
Bad example
250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01
250-HP-1401 CCT10: SPARE
I have extracted the singular number from the rest of the sting hoping i could just low to high sorted them and all would fall in place. but im coming up with a invalid procedure call?