topic Re: Purgechar function in QlikView

Purgechar function

Wed, 31 Dec 2014 11:12:22 GMT

Hi everybody,

i have an issue, i got a field, and i want to delete de character "

So i found the purgechar function, and i use it like that:

purgechar(NF4_Fournisseurs_QVD.N°,' " ') as NF4_Fournisseurs_QVD.N°,

I don't have an error, but nothing change, the character is still present.

Anyone can help me?

Thanks a lot !!

Re: Purgechar function

Colin-Albert — Wed, 31 Dec 2014 11:18:08 GMT

Try purging the ascii code value instead. 34 is the ascii code for "

purgechar(NF4_Fournisseurs_QVD.N°, chr(34) ) as NF4_Fournisseurs_QVD.N°

Re: Purgechar function

PrashantSangle — Wed, 31 Dec 2014 11:18:10 GMT

Hi,

Use Chr(34) instead of "

Regards

Re: Purgechar function

Anonymous — Wed, 31 Dec 2014 11:19:55 GMT

This works fine for me :

=purgechar('qwe"rty' , '"' )

I suspect you have unwanted spaces in your string.

Re: Purgechar function

its_anandrjs — Wed, 31 Dec 2014 11:22:30 GMT

Hi,

Which character you want to Purge.

Regards,

Anand

Re: Purgechar function

its_anandrjs — Wed, 31 Dec 2014 11:25:38 GMT

By Purgerchar it is working check this and if it is ( " ).

LOAD purgechar(Str,' " ') as NF4_Fournisseurs_QVD.N°,Str;

LOAD * Inline

[

Str

Teststring "TesttestStr

];

Re: Purgechar function

Wed, 31 Dec 2014 11:31:24 GMT

PurgeChar(s1, s2)

Returns the string s1 less all characters contained in string s2.

Example:

purgechar ( 'q1li2kview3','123' ) returns 'qlikview'

Re: Purgechar function

MK_QSL — Wed, 31 Dec 2014 12:07:32 GMT

use

TRIM(NF4_Fournisseurs_QVD.N°) as NF4_Fournisseurs_QVD.N°

Re: Purgechar function

Wed, 31 Dec 2014 13:33:35 GMT

Hi thanks a lot everybody but that's not good, and i try every technics..

purgechar(trim(NF4_Client_QVD.N°),chr(34)) as NF4_Client_QVD.N°,

trim(NF4_Client_QVD.N°),chr(34)) as NF4_Client_QVD.N°,

OR with (") instead of chr(34) ...

Re: Purgechar function

Colin-Albert — Wed, 31 Dec 2014 15:30:03 GMT

Are you sure the character is a double quote (ascii 34) and not two single quotes (ascii 39)? Try replacing chr(39).

Otherwise you could use keepchar() and list the characters that you wish to keep, any other characters are removed.