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...") |
|||
| Line 1: | Line 1: | ||
| − | + | =TRIM(Value)= | |
| − | |||
| − | |||
where, | where, | ||
| + | *<math>Value</math> a text value from which spaces are to be removed. | ||
| − | + | TRIM() removes the extra leading or 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=" " | | ||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/CLEAN | CLEAN]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Trim_(programming) Trimming] | ||
| + | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
Revision as of 20:40, 6 February 2014
TRIM(Value)
where,
- a text value from which spaces are to be removed.
a text value from which spaces are to be removed.TRIM() removes the extra leading or trailing spaces from the given text, excluding the single spaces between words.
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: