topic Re: Are Keepchar & Purgechar case sensitive? in QlikView

Are Keepchar & Purgechar case sensitive?

Wed, 25 Nov 2020 16:16:04 GMT

Are keepchar & purgechar case sensitive? For example, if I want to purge all occurrences of the letter E (both upper and lower case), would I need to say purgechar(FIELD1,'Ee') as NEW_FIELD

Re: Are Keepchar & Purgechar case sensitive?

MK_QSL — Thu, 29 Dec 2016 22:11:10 GMT

Yes PurgeChar and KeepChar are case sensitive.

You need to write...

PurgeChar(FIELD,'Ee') as NEW_FIELD

Re: Are Keepchar & Purgechar case sensitive?

el_aprendiz111 — Thu, 29 Dec 2016 22:24:35 GMT

Hi,

1 example:

PurgeChar(FIELD,'0123456789$*-@#&') AS FIELD_CLEAR,
KeepChar(FIELD_CODE,'0123456789') AS CODE_CLEAR;

LOAD * Inline
[
FIELD, FIELD_CODE
Jhons09&5, 0001DSFJHDS
Alf$*--15, 0002SDFSSDS
Don@#$, DFDSFSDR0003DSFJHDS
Mich0123456789, DFGDFRG0004DSFJHDS

];

Re: Are Keepchar & Purgechar case sensitive?

el_aprendiz111 — Thu, 29 Dec 2016 22:26:07 GMT

escese me:

LOAD *,
PurgeChar(FIELD,'0123456789$*-@#&') AS FIELD_CLEAR,
KeepChar(FIELD_CODE,'0123456789') AS CODE_CLEAR;
LOAD * Inline
[
FIELD, FIELD_CODE
Jhons09&5, 0001DSFJHDS
Alf$*--15, 0002SDFSSDS
Don@#$, DFDSFSDR0003DSFJHDS
Mich0123456789, DFGDFRG0004DSFJHDS

];

Re: Are Keepchar & Purgechar case sensitive?

sunny_talwar — Thu, 29 Dec 2016 23:11:27 GMT

Or you can do this:

PurgeChar(Upper(FIELD1),'E')

PurgeChar(Lower(FIELD1),'e')

Re: Are Keepchar & Purgechar case sensitive?

swuehl — Thu, 29 Dec 2016 23:30:12 GMT

Sunny, wouldn't this potentially change also the case of characters one may want to keep?

Re: Are Keepchar & Purgechar case sensitive?

sunny_talwar — Thu, 29 Dec 2016 23:43:15 GMT

Yes it would ...

But at times that might be acceptable. In times it is not, I would use Manish's script

Re: Are Keepchar & Purgechar case sensitive?

Clever_Anjos — Fri, 30 Dec 2016 01:42:11 GMT

afaik almost all qv functions are case sensitive

Re: Are Keepchar & Purgechar case sensitive?

Fri, 30 Dec 2016 20:34:36 GMT

Thanks much.