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 index value for the first character of the input string.

  • 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.
  • If the function cannot resolve a Unicode character from the first character, it returns a null value. 

D s
snippetBasic

Column reference example:

D code

derive type:single value:UNICODE(MyChar)

Output: The Unicode index value for the first character in the MyChar column is written to the new column. 

String literal example:

D code

derive type:single value:UNICODE('A')

Output: The integer 65 is written to the new column.

D s
snippetSyntax

D code

derive type:single value:UNICODE(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal the Unicode value of which is generated

D s lang notes

column_string

Name of the column or string literal, the first character of which is converted to its corresponding Unicode value.

Info

NOTE: If the input string contains multiple characters, the first character is mapped to its Unicode value, and the rest are ignored.

  • Missing string or column values generate missing string results.
  • String constants must be quoted ('Hello, World').
  • Multiple columns and wildcards are not supported.

D s
snippetusage

Required?Data TypeExample Value
YesString literal or column referencemyColumn

D s
snippetExamples

Example - char and unicode functions

Include Page
EXAMPLE - UNICODE Function
EXAMPLE - UNICODE Function

D s also
labelstring