Room Finish schedule - question on sorting

[chris.pittman]

I have a room finish schedule I need to sort in a different way than I'm used to. For example the room numbers are in a format like this, "31B02" "31C07" ... where the first numbers (31) coincide with the floor level, letter coincides with function, and second numbers coincide with actual room number.

For my schedule I have the sorting set up to sort the number, by ascending and it does a fine job putting them in order .. until it sees the letter then it puts the letters in order ... followed by the next number

Basically what I need for it to do is to ignore the letter - and sort the second set of numbers.

Is it possible to do this? I can't seem to get it to behave correctly.

Thanks

[chris.pittman]

figured it out .. had to create another project parameter for the rooms that combined the first and second number so it sorted that way