Magic ETL String Operations - Substring - Allow empty length

GrantSmith
GrantSmith Coach
edited February 17 in Ideas Exchange

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!**
Tagged:
6
6 votes

· Last Updated

This discussion has been closed.