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