Difference between revisions of "Manuals/calci/TRIM"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions 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 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,

  • 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.
  • 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

TRIM

See Also

References