Difference between revisions of "Manuals/calci/CODE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CODE'''(Text) where, '''Text''' - is the text for which you want the code of the first charcater. </di...")
 
 
(14 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''CODE (Text) '''</div><br/>
 +
*<math>Text</math> is the character for which you want the code.
 +
**CODE(), returns a numeric code for the first character in a text string.
  
−
'''CODE'''(Text)
+
==Description==
 +
*CODE()gives a specific CODE for the string entered.
 +
*The <math>Text</math> can be of any length in which first character will be taken.
 +
*The <math>Text</math> can be a text directly or indirectly like cell reference.
 +
*The character is from the character set used in our system.
 +
*Returns a numeric code for the first character of a string.
 +
*It varies according to Operating environment.
 +
{|class="wikitable"
 +
|-
 +
!Operating
 +
!Character Set
 +
|-
 +
|Windows
 +
|ANSI
 +
|-
 +
|Macintosh
 +
|Macintosh Character Set
 +
|}
 +
 
 +
==Examples==
 +
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
! =CODE("string")
 +
! string
 +
! Result
 +
 
 +
|-
 +
|- class="odd"
 +
|=CODE("ஸ")
 +
|ஸ
 +
|3000
  
−
where,
+
|- class="even"
 +
|=CODE("string")
 +
|d
 +
|100
  
−
'''Text''' - is the text for which you want the code of the first charcater.
+
|- class="odd"
 +
|=CODE(":")
 +
|:                                     
 +
|58
  
−
</div>
+
|- class="even"
−
----
+
|=CODE("Y")
−
<div id="1SpaceContent" class="zcontent" align="left">Returns a numeric code for the first charcter in a text string.</div>
+
|Y
−
----
+
|89
−
<div id="7SpaceContent" class="zcontent" align="left">It varies according to Operating environment.</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
CODE
+
|- class="odd"
 +
|=CODE("!")
 +
|!
 +
|33
  
−
</div></div>
+
|- class="odd"
−
----
+
|=CODE("abc".split(""))
−
<div id="8SpaceContent" class="zcontent" align="left">
+
|"abc"
 +
| 97 98 99
  
−
Lets see an example in (Column1, Row1)
 
  
−
<nowiki>=CODE("S")</nowiki>
+
|}
  
−
It returns 83.
+
==Related Videos==
  
−
Consider an another example in (Column2,Row3)
+
{{#ev:youtube|q29nJKewxHk|280|center|CODE}}
  
−
<nowiki>=CODE("~")</nowiki>
+
==See also==
  
−
CODE returns 126.
+
*[[Manuals/calci/CHAR| CHAR]]
 +
*[[Manuals/calci/PRODUCT| PRODUCT]]
  
−
</div>
+
==References==
−
----
+
[http://en.wikipedia.org/wiki/Summation SUM]
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </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
 
−
| Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f" | 83
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 126
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="  SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
 
−
----
+
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 06:49, 4 February 2020

CODE (Text)


  • is the character for which you want the code.
    • CODE(), returns a numeric code for the first character in a text string.

Description

  • CODE()gives a specific CODE for the string entered.
  • The can be of any length in which first character will be taken.
  • The can be a text directly or indirectly like cell reference.
  • The character is from the character set used in our system.
  • Returns a numeric code for the first character of a string.
  • It varies according to Operating environment.
Operating Character Set
Windows ANSI
Macintosh Macintosh Character Set

Examples

=CODE("string") string Result
=CODE("ஸ") ஸ 3000
=CODE("string") d 100
=CODE(":") : 58
=CODE("Y") Y 89
=CODE("!") ! 33
=CODE("abc".split("")) "abc" 97 98 99


Related Videos

CODE

See also

References

SUM


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CODE&oldid=212653"