I need to extract data from a string but I can't use charindex. What should I use?


So in Beast Mode, I want to calculate a new field from a current field. I want to get the first two pieces of data from a string like

Email: DHE: DHE:read-more-horoscope-button

so that the new field would read 

Email: DHE


The pieces of data are 1) not a uniform character length, and 2) sometimes this current field only includes the two pieces (like "Navigation:Readings"). 


Any help with SQL suggestions is appreciated. Thanks!