SUBSTRING
Usage
Use this function to extract a sub string from value
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | STRING | .VALUE |
Syntax:
1 |
|
Arguments:
Parameter_1
initial value: any column field value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant between quotation marks ("constant"
), System Variables or function-returned value
Parameter_2
start index
Parameter_3 (optional)
the number of characters to extract. If not specified take text from start index to the end
Note
The text index is 1-based
Return Value
String
Example 1
Formula
=SUBSTRING("Welcome to eLegere Smart Intelligece"; 11; 8)
Description
Return the substring of the string Welcome to eLegere Smart Intelligence starting from characters 11 and taking 8 characters
Result
eLegere
Example 2
Formula
=SUBSTRING(#StorageExample.Column.VALUE; 11)
Description
Return the substring of the field Column of Storage StorageExample starting from characters 11 and taking all the characters until the end
Result
String