Difference between revisions of "Manuals/calci/CODE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(11 intermediate revisions by 5 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''CODE(text)'''</div><br/>
+
<div style="font-size:30px">'''CODE (Text) '''</div><br/>
*<math>text</math> is the character for which you want the ANSI code.
+
*<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.
  
 
==Description==
 
==Description==
*Returns a numeric code for the first character of a text string.
+
*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.
 
*It varies according to Operating environment.
 +
{|class="wikitable"
 
|-
 
|-
 
!Operating
 
!Operating
 
!Character Set
 
!Character Set
 
|-
 
|-
|
+
|Windows
|
+
|ANSI
 
|-
 
|-
 +
|Macintosh
 +
|Macintosh Character Set
 +
|}
  
 
==Examples==
 
==Examples==
 +
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
! =CODE("string")
 +
! string
 +
! Result
  
Lets see an example in (Column1, Row1)
+
|-
 +
|- class="odd"
 +
|=CODE("ஸ")
 +
|ஸ
 +
|3000
 +
 
 +
|- class="even"
 +
|=CODE("string")
 +
|d
 +
|100
 +
 
 +
|- class="odd"
 +
|=CODE(":")
 +
|:                                     
 +
|58
 +
 
 +
|- class="even"
 +
|=CODE("Y")
 +
|Y
 +
|89
 +
 
 +
|- class="odd"
 +
|=CODE("!")
 +
|!
 +
|33
 +
 
 +
|- class="odd"
 +
|=CODE("abc".split(""))
 +
|"abc"
 +
| 97 98 99
  
=CODE("S")
 
  
It returns 83.
+
|}
  
Consider an another example in (Column2,Row3)
+
==Related Videos==
  
=CODE("~")
+
{{#ev:youtube|q29nJKewxHk|280|center|CODE}}
CODE returns 126.
 
  
 
==See also==
 
==See also==
Line 33: Line 74:
 
==References==
 
==References==
 
[http://en.wikipedia.org/wiki/Summation SUM]
 
[http://en.wikipedia.org/wiki/Summation SUM]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 07: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