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
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有