CHAR function
This topic describes the formula syntax and usage of the CHAR function in the Data Quality Execute Formula transform.
Description
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files or data sources on other types of computers into characters.
Syntax
CHAR(number)The CHAR syntax has the following argument:
- number Required. A number between 1 and 255 specifying a character. The character is from the character set used by Data Integrity Suite.
Example
Data: 70, 87, 68 in the CharCode field.
| Formula | Description | Result |
|---|---|---|
CHAR([CharCode]) |
Character represented by 70. | F |
CHAR([CharCode]) |
Character represented by 87. | W |
CHAR([CharCode]) |
Character represented by 68. | D |