Difference between revisions of "Manuals/calci/CODE"
Jump to navigation
Jump to search
| (13 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CODE( | + | <div style="font-size:30px">'''CODE (Text) '''</div><br/> |
| − | *<math>Text</math> is the | + | *<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. | ||
| − | Returns a numeric code for the first | + | ==Description== |
| − | It varies according to Operating environment. | + | *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 | ||
| + | |} | ||
| − | CODE | + | ==Examples== |
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
| + | |- class="even" | ||
| + | ! =CODE("string") | ||
| + | ! string | ||
| + | ! Result | ||
| + | |- | ||
| + | |- class="odd" | ||
| + | |=CODE("ஸ") | ||
| + | |ஸ | ||
| + | |3000 | ||
| + | |- class="even" | ||
| + | |=CODE("string") | ||
| + | |d | ||
| + | |100 | ||
| − | + | |- class="odd" | |
| + | |=CODE(":") | ||
| + | |: | ||
| + | |58 | ||
| − | =CODE(" | + | |- class="even" |
| + | |=CODE("Y") | ||
| + | |Y | ||
| + | |89 | ||
| − | + | |- class="odd" | |
| + | |=CODE("!") | ||
| + | |! | ||
| + | |33 | ||
| − | + | |- class="odd" | |
| + | |=CODE("abc".split("")) | ||
| + | |"abc" | ||
| + | | 97 98 99 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|q29nJKewxHk|280|center|CODE}} | ||
| + | |||
| + | ==See also== | ||
| + | |||
| + | *[[Manuals/calci/CHAR| CHAR]] | ||
| + | *[[Manuals/calci/PRODUCT| PRODUCT]] | ||
| + | |||
| + | ==References== | ||
| + | [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.
is the character for which you want the code.
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
See also
References