Extract all text after specific words

[jesuisbo]

Hi all,

Though I've read several posts re. this topic I still can't seem to figure out how I can extract text after specific words in a text string. 

Random string of words. Cover: Mike Carren 

Random string of words. Photo: Kate Moss

I want to extract the text after both the words "Cover:" and "Photo:" so I can extract the names in the dataset.

What would be the most convenient way of doing this? 

Many thanks!

[LordNeilLord · Accepted solution]

Hey @jesuisbo

The easiest way would be the regex tool in Parse mode, using this regex: .*?:\s(.*)

[jesuisbo]

Problem solved, thank you @LordNeilLord!