I am trying to extract a specific text from a cell with text up to the first delimiter from its left i.e.

(Green Tuesday)-(Yellow Monday)-(Black Friday)(Sunny Sunday)-(Purple Wednesday)

I would like to search for '(Sunny Sunday)' and the text up to the first delimiter ('-') from its left so resulting in

(Black Friday)(Sunny Sunday)

I have searched here but could not find anything that fit my query.

Thanks