Difference between revisions of "Manuals/calci/TRIM"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| 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 == | ||
| Line 50: | Line 48: | ||
| − | [[Z_API_Functions | List of Main Z Functions]] | + | *[[Z_API_Functions | List of Main Z Functions]] |
| − | [[ Z3 | Z3 home ]] | + | *[[ Z3 | Z3 home ]] |
Latest revision as of 16:26, 8 August 2018
TRIM (Value)
where,
- 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.
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