Hive:在字符的第一次和最后一次出现之间提取字符串

I have a Hive table column which has string separated by '-' and i need to extract the string between first and last occurrence of '-'I have a Hive table column which has string sep