RIGHT
Usage
Use this function to get the right 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
=RIGHT("Digital transformation with eLegere"; 7)
Description
Return the right part of the string Digital transformation with eLegere taking 7 characters
Result
eLegere
Example 2
Formula
=RIGHT(#StorageExample.Column.VALUE; 7)
Description
Return the right part of the field Column of Storage StorageExample taking 7 characters
Result
String