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

MaureenDIG1

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! 

 

BlueRooster

My initial thoughts would be to use the SUBSTRING_INDEX and SUBSTRING functions. Here's some info on SUBSTRING_INDEX https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_substring-index

 

This would allow you to find the 2nd occurance of a delimeter that you define and then you can use that with the substring function to return the piece of the text string that you want.

 

Let me know if you have any more questions,

ValiantSpur