topic Re: Viewing Special Characters in Qlikview in QlikView

Viewing Special Characters in Qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Viewing Special Characters in Qlikview

ahaahaaha — Wed, 02 Aug 2017 08:05:56 GMT

Hi,

May be try use function Ord()?

Re: Viewing Special Characters in Qlikview

Thu, 03 Aug 2017 05:25:29 GMT

Hi Deepika,

May be try use function keepchar().

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

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

Re: Viewing Special Characters in Qlikview

Thu, 03 Aug 2017 05:35:10 GMT

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 : @#&@