Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

Generates the Unicode character corresponding to an inputted Integer value. 

Unicode  is a digital standard for the consistent encoding of the world's writing systems, so that representation of character sets is consistent around the world. 

  • The first 256 Unicode characters (0, 255) correspond to the ASCII character set.
  • Input values for the CHAR function should be of integer type. Decimal type column data can be used as input. However, if the data contains digits to the right of the decimal point, the CHAR function returns a missing value.
  • If the function cannot evaluate the numeric data, a null value is returned.

D s
snippetBasic

Column reference example:

D code

derive type:single value:CHAR(MyCharIndex)

Output: The Unicode value for the number in the MyCharIndex column is written to the new column. 

String literal example:

D code

derive type:single value:CHAR(65)

Output: The string A is written to the new column.

D s
snippetSyntax

D code

derive type:single value:CHAR(index_value)

ArgumentRequired?Data TypeDescription
index_valueYinteger (positive)Unicode index value of the character

D s lang notes

index_value

Unicode index value of the character to generate or match.

  • The Unicode character set contains up 1,114,112 characters. Most uses rely on the first 10,000 characters.
  • Value must be less than end_index.

D s
snippetusage

 

Required?Data TypeExample Value
YesInteger (non-negative)65

D s
snippetExamples

Example - char and unicode functions

Include Page
EXAMPLE - UNICODE Function
EXAMPLE - UNICODE Function

D s also
labelstring