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:
- 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