Difference between revisions of "Manuals/calci/CHAR"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CHAR'''(Number) where, '''Number''' - is the number for which character you want. </div> ---- <div id...")
 
 
(21 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''CHAR (Number) '''</div><br/>
  
−
'''CHAR'''(Number)
+
*where <math>Number</math> is a number to find the UTI character.
 +
**CHAR(),returns the character specified by the code number.
  
−
where,
+
==Description==
  
−
'''Number''' - is the number for which character you want.
+
*This function gives the UTI characters of a given number.
 +
*UTI is stands for the Uniform Type Identifier.
 +
*It is the Text string used to identify uniquely for given class or type of a item.
 +
*UTI use a reverse-DNS naming structure which is including the ASCII characters.
 +
*Also UTI support multiple inheritance, allowing files to be identified with any number of relevant types, as appropriate to the contained data. 
 +
*CHAR()gives a specific character for a number.
 +
*Also the number is starting from 1, but there is no restriction for the final number.
 +
*Because CALCI is supporting for many languages also.
 +
*The <math>Number</math> can be a number directly or indirectly like cell reference.
 +
*The character is from the character set used in our system.
 +
**CHAR(65)
 +
**CHAR(B5), where B5 is the cell number
 +
**CHAR(100)
  
−
</div>
+
==ZOS==
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">Returns the character by a numeric code. </div>
 
−
----
 
−
<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">
 
  
−
CHAR
+
*The syntax for CHAR function in ZOS is CHAR(number)
 +
*<math>number</math> is the number to find the character for the specified by the code number.
 +
*char(5000..5050)
 +
{{#ev:youtube|4aZPkwFPkI8|280|center|Character}}
  
−
</div></div>
+
==Examples==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column1, Row2)
 
−
 
 
−
<nowiki>=CHAR(R1C1)</nowiki>
 
−
 
 
−
It returns ÿ.
 
−
 
 
−
Consider an another example in (Column2,Row1)
 
−
 
 
−
<nowiki>=CHAR(126)</nowiki>
 
−
 
 
−
CHAR returns ~.
 
−
 
 
−
</div>
 
−
----
 
−
<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"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
! CHAR(number)
−
| Column1
+
! nb
−
| Column2
+
! Result
−
| Column3
+
 
−
| Column4
+
|-
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
|CHAR(nb)
−
| class="sshl_f" | 255
+
|3000
−
| class="sshl_f" | ~
+
|ஸ
−
|
+
 
−
|
 
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
|CHAR(nb)
−
| class="sshl_fSelectTD ChangeBGColor SelectTD " |
+
|100
−
<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>ÿ
+
|d
−
| class="  " |
+
 
−
|
 
−
|
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| CHAR(nb)
−
| class="  " |
+
|58                                     
−
|
+
|:
−
|
+
 
−
|
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
| CHAR(nb)
−
|
+
|89
−
|
+
|Y
−
|
+
 
−
|
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
|CHAR(nb)
−
|
+
|33
−
|
+
|!
−
|
+
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
|
 
−
|
 
−
|
 
−
|
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==Related Videos==
−
----
+
 
 +
{{#ev:youtube|boyqJlLbD24|280|center|CHAR}}
 +
 
 +
==See Also==
 +
 
 +
*[[Manuals/calci/CHR| CHR]]
 +
*[[Manuals/calci/CODE| CODE]]
 +
 
 +
==References==
 +
[http://en.wikipedia.org/wiki/Uniform_Type_Identifier  UTI values]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:55, 9 August 2018

CHAR (Number)


  • where is a number to find the UTI character.
    • CHAR(),returns the character specified by the code number.

Description

  • This function gives the UTI characters of a given number.
  • UTI is stands for the Uniform Type Identifier.
  • It is the Text string used to identify uniquely for given class or type of a item.
  • UTI use a reverse-DNS naming structure which is including the ASCII characters.
  • Also UTI support multiple inheritance, allowing files to be identified with any number of relevant types, as appropriate to the contained data.
  • CHAR()gives a specific character for a number.
  • Also the number is starting from 1, but there is no restriction for the final number.
  • Because CALCI is supporting for many languages also.
  • The can be a number directly or indirectly like cell reference.
  • The character is from the character set used in our system.
    • CHAR(65)
    • CHAR(B5), where B5 is the cell number
    • CHAR(100)

ZOS

  • The syntax for CHAR function in ZOS is CHAR(number)
  • is the number to find the character for the specified by the code number.
  • char(5000..5050)
Character

Examples

CHAR(number) nb Result
CHAR(nb) 3000 ஸ
CHAR(nb) 100 d
CHAR(nb) 58 :
CHAR(nb) 89 Y
CHAR(nb) 33 !

Related Videos

CHAR

See Also

References

UTI values


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