Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
You could create a sort column with this formula, =SubField(SubField(Dept,'(',2),')',1).