column_string

Name of the column or string literal, the first character of which is converted to its corresponding Unicode value.

NOTE: If the input string contains multiple characters, the first character is mapped to its Unicode value, and the rest are ignored.

Missing string or column values generate missing string results.

String constants must be quoted ('Hello, World').

Multiple columns and wildcards are not supported.

Usage Notes:

Required?

Data Type

Example Value

Yes

String literal or column reference

myColumn

Examples

Example - char and unicode functions

In this example, you can see how the CHAR function can be used to convert numeric index values to Unicode characters, and the UNICODE function can be used to convert characters back to numeric values.

Source:

The following column contains some source index values:

index

1

33

33.5

34

48

57

65

90

97

121

254

255

256

257

9998

9999

Transform:

When the above values are imported to the Transformer page, the column is typed as integer, with a single mismatched value (33.5). To see the corresponding Unicode characters for these characters, enter the following transform:

derive type:single value: CHAR(index) as: 'char_index'

To see how these characters map back to the index values, now add the following transform: