LAST
Returns the last character(s) of a string, based on the number of characters you specify.
Syntax
LAST integer CHARACTERS OF string LAST CHARACTER OF string |
Inputs
- integer - A positive integer value. This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value. LAST CHARACTER OF can be used to retrieve only the last character of the string.
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
If you prefer a functional syntax, you can use the STR_BACK ( string, integer ) function. Example: STR_BACK("Blueriq", 3) = "riq" |
Examples
| Entity.attribute | Value | Type |
|---|---|---|
| File.name | "Thisfile_1.doc" | String |
| File.extension | 3 | Integer |
| Expression | Alternative syntax | Result | Type |
|---|---|---|---|
| LAST File.extension CHARACTERS OF File.name | STR_BACK( File.name , File.extension ) | "doc" | String |
| LAST CHARACTER OF File.name | STR_BACK( File.name , 1 ) | "c" | String |
| LAST 4 CHARACTERS OF "pieceofcake" | STR_BACK( "pieceofcake" , 4 ) | "cake" | String |