I use CR 2008 and have a field called itemCode which is a string and has values like R1, R10, R2, R44.002, R300, R9 etc. The "R" is always present and always at the beginning.
I need to sort them numericaly so that the result is R1, R2, R10 etc. Currently it sorts like R1, R10, R2 etc.
I need a formula to truncate the "R" and cast it to a number and then I can sort on the formula value.
Any help would be greatly appreciated.