Making AES31/12/200KG into 200
Posted by Tim on June 21, 2001 8:25 AM
Does any1 know how i can make a collumn with codes in like this into just the number after the last delimiter.
AES31/12/200KG into 200
SP27/12/120KG into 120
The first part b4 the 1st "/" varies in size. but the rest of the code will always be the same size.... with bit between the 1st & 2nd "/" always being 2 characters long and the bit after the last delimiter will always be five characters long.