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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive