Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I am hoping you can help.
Some fields in our databases store some characters in their ASCII format and as they are pulling into Qlik Sense they are appearing as their ASCII stored variables.
Two questions,
Can anyone advise of the expression that will be required to convert these ASCII codes back to their characters on the front end as a quick fix
and secondly,
Can anyone advise of the code that would be required on LOAD to get these changed?
Example.
(BT)
shows as ( BT )
I would like this to appear on the dashboard as (BT)
Just a quick update, the quick fix i've come up with so far is
=Replace(Replace(Replace(Replace(FieldName
, '(', '(' )
, ')', ')' )
, '%', '%' )
, ';', ';' )
Although there may be better alternatives.
A better way as nesting multiple replace() would be a mapping with mapsubstring(). See here what is meant:
Passing-parameter-strings-that-contain-special-characters
- Marcus
Would you be able to share more sample data?