Magic ETL String Operations - Substring - Allow empty length

GrantSmith
GrantSmith Indiana πŸ₯·

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

Β· Last Updated

This discussion has been closed.