Difference between revisions of "Manuals/calci/TRIM"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TRIM'''(Value) where, '''Value''' - is the text from which you removed spaces. </div> ---- <div id="1S...") |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''TRIM (Value) '''</div><br/> |
| − | |||
| − | '''TRIM''' | ||
| − | |||
where, | where, | ||
| + | *<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. | ||
| − | + | == Description == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | TRIM | + | 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. | |
| + | *<math>Value</math> is a text value and should be enclosed in double quotes (e.g. "TEXT"), when directly entered in the command. | ||
| − | + | == Examples == | |
| − | TRIM | + | Consider the following examples that demonstrate the use of TRIM function: |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Function''' |
| − | | | + | | class=" " | '''Output''' |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" |TRIM(" Zcubes") |
| − | + | | class="sshl_f" |Zcubes | |
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" " | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |TRIM(" TRIM Function ") | |
| − | + | | class="sshl_f" |TRIM Function | |
| − | | class=" " | | ||
| − | |||
| − | | class=" " | | ||
|} | |} | ||
| − | + | ==Related Videos== | |
| − | + | ||
| + | {{#ev:youtube|SZRT5GNIxxM|280|center|TRIM}} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/CLEAN | CLEAN]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Trim_(programming) Trimming] | ||
| + | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ 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