Extract specific data from inconsistent string into a new column

Hi all   I need to extract some specific text from a string to be used as a future reference, problem is due the received data not being very consistant, I've tried using the extract funtion in pow...