if(INSTR({string_or_var}, '-'), (REPLACE( SUBSTRING( SUBSTRING_INDEX(  {string_or_var},  '-', 1 ) ,
LENGTH( SUBSTRING_INDEX(  {string_or_var},  {string_or_var}, 1 -1 ) ) +1 ) , '-',  '' )), '')

if(INSTR({string_or_var}, '-'), (REPLACE( SUBSTRING( SUBSTRING_INDEX(  {string_or_var},  '-', 2 ) ,
LENGTH( SUBSTRING_INDEX(  {string_or_var},  {string_or_var}, 2 -1 ) ) +1 ) , '-',  '' )), '')