CODE function
This topic describes the formula syntax and usage of the CODE function in the Data Quality Execute Formula transform.
Description
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by Data Integrity Suite.
Syntax
CODE(text)The CODE syntax has the following argument:
- text Required. The text for from which to code the first character.
Example
Data: Florence, Willamina, Decatur in the City field.
| Formula | Description | Result |
|---|---|---|
CODE([City]) |
Numeric code for first character in "Florence". | 70 |
CODE([City]) |
Numeric code for first character in "Willamina". | 87 |
CODE([City]) |
Numeric code for first character in "Decatur". | 68 |