| Excerpt |
|---|
Generates the Unicode index value for the first character of the input string. |
- Unicode is a digital standard for the consistent encoding of the world's writing systems, so that representation of character sets is consistent around the world.
- The first 256 Unicode characters (0, 255) correspond to the ASCII character set.
- If the function cannot resolve a Unicode character from the first character, it returns a null value.
Column reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:unicode(MyChar) |
|---|
|
unicode(MyChar) |
Output: Returns Unicode index value for the first character in the MyChar column.
String literal example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:unicode('A') |
|---|
|
unicode('A') |
Output: Returns the integer 65.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:unicode(column_string) |
|---|
|
unicode(column_string) |
| Argument | Required? | Data Type | Description |
|---|
| column_string | Y | string | Name of the column or string literal the Unicode value of which is generated |
column_string
Name of the column or string literal, the first character of which is converted to its corresponding Unicode value.
| Info |
|---|
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.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Example - char and unicode functions
| Include Page |
|---|
| EXAMPLE - UNICODE Function |
|---|
| EXAMPLE - UNICODE Function |
|---|
|
