Sort Fields (Alpha and Numeric)

[peterkumar]

Good Afternoon - 

I am looking for some help with a sort - field has strings like these - 

- this field(T12345)

- that field(P34567)

- good field(T23456)

- another field(P12345)

Need to sort by code in the parenthesis

- P12345 should be first; T23456 should be last.

Thanks very much!!

[jwjackso]

You could create a sort column with this formula, =SubField(SubField(Dept,'(',2),')',1).