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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 561 Beast Mode
- 8 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive