Manuals/calci/TRIM
Jump to navigation
Jump to search
TRIM (Value)
where,
- TRIM() removes the extra leading and trailing spaces from the given text, excluding the single spaces between words.
is a text value from which spaces are to be removed.
Description
TRIM(Value)
e.g. TRIM(" Good Morning") removes two leading spaces from the text and returns Good Morning as a result.
- TRIM function is used to remove the irregular spacing from the text.
- is a text value and should be enclosed in double quotes (e.g. "TEXT"), when directly entered in the command.
Examples
Consider the following examples that demonstrate the use of TRIM function:
Function | Output |
TRIM(" Zcubes") | Zcubes |
TRIM(" TRIM Function ") | TRIM Function |
Related Videos
See Also
References