OpenBI Docs Buy

Character.FromNumber

The character with a given Unicode number, as a text of one character.

Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Character.FromNumber(number as nullable number) as nullable text
ParameterTypeDescription
numbernullable numberThe character's Unicode code point, such as 65 for A.

Returns

nullable text. A text holding that one character; null when the number is null.

Examples

A letter from its number

Character.FromNumber(65)
"A"

The euro sign

Hexadecimal literals work too: 0x20AC is 8364.

Character.FromNumber(0x20AC)
"€"

Character.ToNumber, Text.ToList.

Last updated · OpenBI Studio 0.3.79