Good afternoon,

I am having trouble with this one today....

I need to extract to a new variable, all the text between two colons if that text between the colons specifically contains the words 'acts on'
For example in the code provided the new var would return the string 'acts on tapeta, good to firm and good to soft going' as it is between the two colons that contain 'acts on'.
If the string does not contain 'acts on' the 'null' can be returned.

Thank you

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str960 productioncomment
"unfurnished filly: fair handicapper: stays 7f: acts on tapeta, good to firm and good to soft going: often races prominently: sold 35,000 gns in July."
end