Viewing Special Characters in Qlikview

[#1]

I have a field INFO in database(Big data) that contains special characters.while taking substring from the field the values are not populated correctly.Not sure if some characters are trimmed.How do i view the special characters in Qlikview to analyse?

[ahaahaaha]

Hi,

May be try use function Ord()?

[#3]

Hi Deepika,

May be try use function keepchar().

Keepchar(string,keep_chars)-> It will give the keepchars

Example : Keepchar('fdf^$%&^%ghgfhuj%^$^%$**(%@@','~!@#$%^&*()')--> It will give ^$%&^%%^$^%$**(%@@

[#4]

Hi Deepika,

test:

load PurgeChar('a@b#c&r@','@#$%^&*()') as newfield

Resident data;

=> It returns other than special characters. output is: abcr

     * data is previously used table.

test2:

load KeepChar('a@b#c&r@','@#$%^&*()') as newfield1

Resident test;

=> It returns special characters which are present in your data. output is : @#&@