How to use a column value as delimiter in spark sql substring?

I am trying to do a substring option on a column with another column as a delimiter, the methods like substring_index() expects string value, could somebody suggest ?