Difference between revisions of "Manuals/calci/TRIM"
| (3 intermediate revisions by 2 users 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 37: | Line 35: | ||
==Related Videos== | ==Related Videos== | ||
| − | {#ev:youtube|SZRT5GNIxxM|280|center|TRIM}} | + | {{#ev:youtube|SZRT5GNIxxM|280|center|TRIM}} |
== See Also == | == See Also == | ||
| Line 47: | Line 45: | ||
*[http://en.wikipedia.org/wiki/Trim_(programming) Trimming] | *[http://en.wikipedia.org/wiki/Trim_(programming) Trimming] | ||
*[http://en.wikipedia.org/wiki/String_(computer_science) String] | *[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,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value}
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(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.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value} 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