LEFT
Usage
Use this function to get the left part of a character string with the specified number of characters
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | STRING | .VALUE |
Syntax
1 |
|
Arguments
String
any column field string value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), string constant between quotation marks ("constant"
), System Variables or function-returned string value
Number
number of characters
Note
This function is mainly used in calculated fields or as argument of conditional expressions and is not key sensitive
Return Value
String
Examples
Example 1
Formula
=LEFT("eLegere Smart Intelligence"; 7)
Description
Return the left part of the string eLegereSmart Intelligence taking 7 characters
Result
eLegere
Example 2
Formula
=LEFT(#StorageExample.Column.VALUE; 7)
Description
Return the left part of the field Column of Storage StorageExample taking 7 characters
Result
String