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.


= 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”.