=right(Fields!SubTaskKPIContext.Value,instr(strreverse(Fields!SubTaskKPIContext.Value)," ||| ")-1) =left(Fields!SubTaskKPIContext.Value,instr(Fields!SubTaskKPIContext.Value," ||| ")-1) Split string left or right from delimiter.