EXAMPLE - UNICODE Function

Contents:

NOTE: Designer Cloud Powered by Trifacta Educational is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

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.

Functions:

Item	Description
$strPageTitle	Error rendering macro 'excerpt-include' No link could be created for '$strPageTitle'.
$strPageTitle	Error rendering macro 'excerpt-include' No link could be created for '$strPageTitle'.

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

Transformation:

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

Transformation Name	`New formula`
Parameter: Formula type	`Single row formula`
Parameter: Formula	`CHAR(index)`
Parameter: New column name	`'char_index'`

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

Transformation Name	`New formula`
Parameter: Formula type	`Single row formula`
Parameter: Formula	`UNICODE(char_index)`
Parameter: New column name	`'unicode_char_index'`

Results:

index	char_index	unicode_char_index
1		1
33	!	33
33.5
34	"	34
48	0	48
57	9	57
65	A	65
90	Z	90
97	a	97
122	z	122
254	þ	254
255	ÿ	255
256	Ā	256
257	ā	257
9998	✎	9998
9999	✏	9999

Note that the floating point input value was not processed.

See Also for EXAMPLE - UNICODE Function:

Error rendering macro 'contentbylabel'

parameters should not be empty

Send Feedback

Page tree

EXAMPLE - UNICODE Function