Manuals/calci/LEN - Revision history

Devika at 21:07, 13 August 2018

2018-08-13T21:07:16Z

Jayaram at 11:42, 14 March 2017

2017-03-14T11:42:47Z

Swapna: /* Examples */

2015-05-10T16:13:18Z

Examples

Swapna at 16:10, 10 May 2015

2015-05-10T16:10:44Z

Swapna at 23:06, 30 January 2014

2014-01-30T23:06:52Z

Swapna at 15:43, 13 January 2014

2014-01-13T15:43:43Z

Swapna at 15:03, 13 January 2014

2014-01-13T15:03:53Z

Swapna at 15:01, 13 January 2014

2014-01-13T15:01:15Z

MassBot1: Created page with "

2013-10-25T02:39:00Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="2"><font face="Arial"> <font color="#484848"> </font></font></font> <font color="#484848"><font face="Ari..."

New page
<div id="6SpaceContent" class="zcontent" align="left"><font size="2"><font face="Arial"> <font color="#484848"> </font></font></font>

<font color="#484848"><font face="Arial"><font size="2">'''LEN'''</font><font size="2">(</font><font size="2">'''txt'''</font><font size="2">)</font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">LEN calculates the number of characters in a text string.</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">LENB calculates the number of bytes used to represent the characters in a text string.</font></font></font>

<font color="#ff0000"><font face="Arial, sans-serif"><font size="2">'''Note'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> LEN works with languages that use the single-byte character set (SBCS)</font></font></font>

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

LEN

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">let’s see an example in (Column1 Row 1)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=LEN(C1R1)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=LEN(“world”) is 5</nowiki></font></font></font>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f " | world
| class="sshl_f" | 5
|
| class=" sshl_f " |
|- class="even"
| class=" " | Row2
| class="sshl_f" |
| class="sshl_fSelectTD SelectTD " |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|
|
|- class="odd"
| Row3
| class=" sshl_f " |
|
|
|
|- class="even"
| Row4
|
|
|
| class=" " |
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
|
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 1: / Line 1: @@
-=LEN(txt)=
+<div style="font-size:30px">'''LEN (Text) '''</div><br/>
+*where, <math>Text</math> is a text string whose length is to be determined.
-*where, <math>txt</math> is a text string whose length is to be determined.
+**LEN(), returns the number of characters in a text string.
 == Description ==
@@ Line 9: / Line 7: @@
 LEN(txt)
-e.g. LEN("String") displays '''6''' as a result.
+e.g. LEN (Text) displays '''6''' as a result.
 *LEN() counts 1 byte per character. LEN() works with the languages that use 'Single Byte Character Set' (SBCS).
-*<math>txt</math> can be any string containing characters, numbers, symbols, blank space etc.
+*<math>Text</math> can be any string containing characters, numbers, symbols, blank space etc.
-*If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
+*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
 == Examples ==

← Older revision		Revision as of 11:42, 14 March 2017
Line 60:		Line 60:
	*[http://en.wikipedia.org/wiki/String_(computer_science) String]		*[http://en.wikipedia.org/wiki/String_(computer_science) String]
	*[http://en.wikipedia.org/wiki/SBCS Single-byte Character Set]		*[http://en.wikipedia.org/wiki/SBCS Single-byte Character Set]
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 41: / Line 41: @@
 |}
-  =LEN(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''8''' as the output. Character '-' is also counted.
+  =LEN(A1) : Calculates the number of characters in a string referenced to cell A1. <br>Displays '''8''' as the output. Character '-' is also counted.
-  =LEN(A2) : Calculates the number of characters in a string referenced to cell A2. Displays '''12''' as the output. Space Character is also counted.
+  =LEN(A2) : Calculates the number of characters in a string referenced to cell A2. <br>Displays '''12''' as the output. Space Character is also counted.
-  =LEN(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output.
+  =LEN(A3) : Calculates the number of characters in a string referenced to cell A3. <br>Displays '''7''' as the output.
   =LEN("<!#!>") :Displays '''5''' as the output.
-  =LEN(A1&A2) : Adds the character length of two strings referenced to cells A1 and A2. Displays '''20''' as the output.
+  =LEN(A1&A2) : Adds the character length of two strings referenced to cells A1 and A2. <br>Displays '''20''' as the output.
-  =LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". Displays '''10''' as the output.
+  =LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". <br>Displays '''10''' as the output.
 ==Related Videos==

@@ Line 47: / Line 47: @@
   =LEN(A1&A2) : Adds the character length of two strings referenced to cells A1 and A2. Displays '''20''' as the output.
   =LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". Displays '''10''' as the output.
 == See Also ==

@@ Line 11: / Line 11: @@
 e.g. LEN("String") displays '''6''' as a result.
-*LEN() counts 1 byte per characters. LEN() works with the languages that use 'Single Byte Character Set' (SBCS).
+*LEN() counts 1 byte per character. LEN() works with the languages that use 'Single Byte Character Set' (SBCS).
 *<math>txt</math> can be any string containing characters, numbers, symbols, blank space etc.
 *If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"><font size="2"><font face="Arial"> <font color="#484848"> </font></font></font>
+=LEN(txt)=
-<font color="#484848"><font face="Arial"><font size="2">'''LEN'''</font><font size="2">(</font><font size="2">'''txt'''</font><font size="2">)</font></font></font>
+*where, <math>txt</math> is a text string whose length is to be determined.
-</div>
+LEN() counts the number of characters in a text string.
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">LEN calculates the number of characters in a text string.</font></font></font>
+== Description ==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">LENB calculates the number of bytes used to represent the characters in a text string.</font></font></font>
+LEN(txt)
-<font color="#ff0000"><font face="Arial, sans-serif"><font size="2">'''Note'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">  LEN works with languages that use the single-byte character set (SBCS)</font></font></font>
+e.g. LEN("String") displays '''6''' as a result.
-</div>
+*LEN counts 1 byte per characters. LEN works with the languages that use 'Single Byte Character Set' (SBCS).
-----
+*<math>txt</math> can be any string containing characters, numbers, symbols, blank space etc.
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+*If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
-LEN
+== Examples ==
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
+| class=" " |
-| class="  " | Column2
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" |Apple Orange
-| class="sshl_f " | world
+| class=" " |
-| class="sshl_f" | 5
+| class=" " |
-−
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" |123*123
-| class="sshl_f" |
+| class=" " |
-| class="sshl_fSelectTD SelectTD " |
+| class=" " |
-<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 |- class="odd"
-| Row3
+| class="sshl_f" |
-| class="                                       sshl_f            " |
+| class=" " |
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =LEN(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''8''' as the output. Character '-' is also counted.
-----
+ =LEN(A2) : Calculates the number of characters in a string referenced to cell A2. Displays '''12''' as the output. Space Character is also counted.