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!
Comments
-
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
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive