Would it work if you split the column using (type)/ as the separator and then just keep the last column?