Text
- Last UpdatedJun 16, 2017
- 1 minute read
|
Function |
Syntax |
Returns |
|---|---|---|
|
@LEFT |
@LEFT("string1",x) |
The leftmost x characters of string1 |
|
@MID |
@MID("string1", x, y) |
The y characters of string1, starting at x characters from the first. For example, @MID("ABCDEFG", 2, 3) returns CDE |
|
@RIGHT |
@RIGHT("string1", x) |
The rightmost x characters of string1 |
|
@TOLOWER |
@TOLOWER("string1") |
The text of string1 in lowercase letters |
|
@TOUPPER |
@TOUPPER("string1") |
The text of string1 in uppercase letters |
|
@TRIM |
@TRIM ("string1") |
The text of string1 with any leading or following spaces removed. For example, @TRIM(" ABCDEFG ") returns ABCDEFG |