select substr('10-10-20-11:bs_sweb16-cpu', instr('10-10-20-11:bs_sweb16-cpu', ':') + 1, instr('10-10-20-11:bs_sweb16-cpu', '-', -1) - instr('10-10-20-11:bs_sweb16-cpu', ':') - 1) from dual;
select substr(substr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
instr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
':') + 1,
length('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface') -
instr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
':')),
1,
instr(substr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
instr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
':') + 1,
length('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface') -
instr('10-13-10-11-11:BS_S9312_03-Vlanif1019-interface',
':')),
'-')-1) as unit_id
from dual;