Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
unknownb
Partner - Contributor III
Partner - Contributor III

Convert ASCII stored in Database To Characters?

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)

Labels (1)
  • acsii

3 Replies
unknownb
Partner - Contributor III
Partner - Contributor III
Author

Just a quick update, the quick fix i've come up with so far is 

 

=Replace(Replace(Replace(Replace(FieldName
, '(', '(' )
, ')', ')' )
, '%', '%' )
, '&#59;', ';' )

Although there may be better alternatives.

marcus_sommer

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

Kushal_Chawda

Would you be able to share more sample data?