Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

index
1
33
33.5
34
48
57
65
90
97
121
254
255
256
257
9998
9999

TransformTransformation:

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

d-

...

trans
RawWrangletrue
p03Value'char_index'
Typestep
WrangleTextderive type:single value: CHAR(index) as: 'char_index'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueCHAR(index)
p03NameNew column name
SearchTermNew formula

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

d-

...

trans
RawWrangletrue
p03Value'unicode_char_index'
Typestep
WrangleTextderive type:single value: UNICODE(char_index) as: 'unicode_char_index'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueUNICODE(char_index)
p03NameNew column name
SearchTermNew formula

Results:

indexchar_indexunicode_char_index
1 1
33!33
33.5  
34"34
48048
57957
65A65
90Z90
97a97
122z122
254þ254
255ÿ255
256Ā256
257ā257
99989998
99999999

...