SUBSTRING Query (9 day n00b question)

Hi
I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_)
How do I get the ID column to return the values after the _ ??
Thanks for any and all support
DanB
Best Answer
-
SUBSTRING_INDEX(
ID
, '_', -1)If I solved your problem, please select "yes" above
1
Answers
-
SUBSTRING_INDEX(
ID
, '_', -1)If I solved your problem, please select "yes" above
1 -
Thank you @ColemenWilson - I'm currently undergoing a 'trial by fire which is on fire' and I'm still getting used to all the functions within Domo 😊
0 -
Haha we all do! Let me know if I can help on anything else!
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive