Spotfire Ideas Portal
Please add function to convert integer to ascii character and vice versa.
Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars.
case
when ([val]>=48) and ([val]<=57) then string([val] - 48)
when ([val]>=65) and ([val]<=90) then Substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ',[val] - 64,1)
when ([val]>=97) and ([val]<=122) then Substring('abcdefghijklmnopqrstuvwxyz',[val] - 96,1)
else null
end
TERR/Python can do this either, but it involves TSSS license and interoperation with other process/service hence slow in nature.
We hope there is a native approach for this.
Thanks.