CHAR

CHAR(value)[source]

Converts an integer or array of integers to corresponding ASCII characters.

This function returns the character represented by an integer value. If an array of integers is provided, it returns an array of corresponding characters. The valid input range is 0–255. If the input is outside this range, blank, or in an error state, the formula will evaluate to an error.

Parameters:

value (Operand | int) – The integer to convert to a character.

Return type:

Formula

Returns:

A formula object that evaluates to the ASCII character.

Raises:

ValueError – If the input is not an integer type or array of integers.

Examples

Single value:

CHAR(65)
# Returns "A"

Array input:

CHAR([65, 66, 67])
# Returns ["A", "B", "C"]

``value`` — accepted types

  • INTEGER

  • INTEGER_ARRAY

Return types

  • STRING

  • STRING_ARRAY