How to filter QTR as T and QTK as K ?

[#1]

Hi All

I have a field name for quotation ref , the format is xx/QTK/xx , i like to filter when QTR it will filter as R and QTK as K. take note that first 2 number some time 2 charater some time 3 charater.

[#2]

Hi Sir Thank you very much it work fine.

[#3]

no problem

[#4]

Hi sir 

I check it work . Many thank

Sent from Samsung Mobile

[#5]

Hi Elga , are you able to give me one more expression at partial reload script , i need a field name = link_key which is autonumber from date and ref. no