Magic ETL String Operations - Substring - Allow empty length
Other languages like SQL allows the length parameter to be optional to pull the rest of the string without having to calculate the length of the string. It'd be great if Magic ETL String Operation tiles would allow the length parameter to be null to follow the same logic as SQL so that I don't have to calculate the length of the string, subtract the start position to get the final length and add that to a column to use in the substring function.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
**Did this solve your problem? Accept it as a solution!**
Tagged:
6
This discussion has been closed.
Categories
- 7.6K All Categories
- Connect
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 23 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 17 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部