OpenBI Docs Buy

UNICODE

The Unicode code point of a text's first character.

Group: Text. Compatible with DAX.

Syntax

UNICODE ( <Text> )
ParameterTypeDescription
TextTextThe text whose first character is wanted; a number becomes text first.

Returns

Whole number. The Unicode code point of the text's first character.

Remarks

  • Only the first character counts. An emoji gives its full code point, even though LEN counts it as two.
  • Empty text and a blank both give BLANK.
  • UNICHAR goes the other way.

Examples

Code points

EVALUATE
ROW (
    "A", UNICODE ( "A" ),
    "Øl", UNICODE ( "Øl" ),
    "😀", UNICODE ( "😀" ),
    "Empty", UNICODE ( "" ),
    "The number 7", UNICODE ( 7 )
)
AØl😀EmptyThe number 7
65216128512(blank)55

UNICHAR, LEFT, EXACT.

Last updated · OpenBI Studio 0.3.74