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.

Supported types:

  • INTEGER

  • INTEGER_ARRAY

Return type:

Formula

Returns:

A formula object that evaluates to the ASCII character.

Supported types:

  • STRING

  • STRING_ARRAY

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"]