Difference between revisions of "Manuals/calci/TRIM"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | =TRIM(Value) | + | <div style="font-size:30px">'''TRIM (Value) '''</div><br/> |
− | |||
where, | where, | ||
*<math>Value</math> is a text value from which spaces are to be removed. | *<math>Value</math> is a text value from which spaces are to be removed. | ||
− | + | **TRIM() removes the extra leading and trailing spaces from the given text, excluding the single spaces between words. | |
− | TRIM() removes the extra leading and trailing spaces from the given text, excluding the single spaces between words. | ||
== Description == | == Description == |
Latest revision as of 16:26, 8 August 2018
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