Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hermannfloimayr
Contributor
Contributor

ASCII to char

can I covert ASCII code from a table to char in QLIK Sense?

Example:

ASCII Code: 116101115116     should convert to "test".

 

 

 

Labels (1)
  • ASCII

12 Replies
mdmukramali
Specialist III
Specialist III

Hi,

Can you attach your excel file?
hermannfloimayr
Contributor
Contributor
Author

Great!! It works! THX

Sri27
Contributor II
Contributor II

This is working fine.

However if there is non converted text has numbers this is not working as expected.

Example of data:  (I am using this to display company name that has special chars)
116101115116    -------test as discussed in the beginning working fine    *****This works fine

1 2 3 ABC company      *********This is failing

3 Trading                      *********This is failing

 

How can I skip the last 2 rows from MapSubString???