The SUBSTR function will return a specified part of the string. The position value is zero based and must be less than the length of the string. The length can be a large number to return the rest of the string.
Syntax
SUBSTR(x,y,z)
Parameters
x = The string which the user wants to be searched for a specific substring to return.
y = The number (integer) of the start position of the text to return.
z = The number (integer) of the length of the return substring.
That is, “Starting at position y within string x, return z characters.”
Data Type Returned
The SUBSTR function will return a text value.
Examples
SUBSTR(“SharpCloud Calculated Values”, 11, 4) will return “Calc”.
SUBSTR(“SharpCloud Calculated Values”, 7, 3) will return “oud”.
SUBSTR(“SharpCloud Calculated Values”, 23, 100) will return “Values”.