Manuals/calci/TRIM - Revision history

Devika at 22:26, 8 August 2018

2018-08-08T22:26:28Z

2017-03-13T07:22:01Z

2017-03-09T11:35:32Z

2015-05-14T20:45:48Z

2015-05-14T20:45:25Z

2014-02-07T01:43:28Z

2014-02-07T01:40:18Z

@@ Line 1: / Line 1: @@
-=TRIM(Value)=
+<div style="font-size:30px">'''TRIM (Value) '''</div><br/>
 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 ==

← Older revision		Revision as of 07:22, 13 March 2017
Line 50:		Line 50:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:35, 9 March 2017
Line 47:		Line 47:
	*[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 ]]

@@ Line 37: / Line 37: @@
 ==Related Videos==
-{#ev:youtube|SZRT5GNIxxM|280|center|TRIM}}
+{{#ev:youtube|SZRT5GNIxxM|280|center|TRIM}}
 == See Also ==

@@ Line 34: / Line 34: @@
 | class="sshl_f" |TRIM Function
 |}
 == See Also ==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=TRIM(Value)=
 where,
-'''Value''' - is the text from which you removed spaces.
+TRIM() removes the extra leading or trailing spaces from the given text, excluding the single spaces between words.
-</div>
+== Description ==
-TRIM
+TRIM(Value)
-</div></div>
+e.g. TRIM("  Good Morning") removes two leading spaces from the text and returns '''Good Morning''' as a result.
-Lets see an example in (Column1, Row1)
+*TRIM function is used to remove the irregular spacing from the text.
-<nowiki>=TRIM("  Zcubes")</nowiki>
+== Examples ==
-TRIM removes the leading space from Zcubes.
+Consider the following examples that demonstrate the use of TRIM function:
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class=" " |
+| class="  " | '''Function'''
-| Column1
+| class="  " | '''Output'''
-| Column2
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" |TRIM(" Zcubes")
-| class="sshl_f" | Zcubes
+| class="sshl_f" |Zcubes
-| class=" " |
 |- class="even"
-| Row6
+| class="sshl_f" |TRIM(" TRIM  Function ")
-| class=" " |
+| class="sshl_f" |TRIM Function
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+== See Also ==
-----