Strip out part of a text field in sql 2008 to leave the required part only

[HelpIsNeeded]

How can you remove a part of a text field in sql but leave the section that is needed such as

the cat went up the hill: the dog followed on behind    the mouse went the other way

(4 spaces between 'behind' and 'the mouse')

'the cat followed on behind' is the only bit I need

Also need to add that the text field varies in length so need to use ':' and ' the mouse' to identify the beginning and end

[Rabbit]

You can use the CHARINDEX function to find the location of those strings and the SUBSTRING function to extract the parts you need.

[SimMed]

DECLARE @X NVARCHAR(MAX) = 'the cat went up the hill: the dog followed on behind the mouse went the other way'
 SELECT SUBSTRING(@X,0,8)+ SUBSTRING(@X,33,20)+ ': '+SUBSTRING(@X,55,9)

Something like that?