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
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!