topic Re: Purgechar syntax problem in QlikView

Purgechar syntax problem

martynlloyd — Tue, 21 Jul 2015 13:15:12 GMT

Hi, I'm trying to remove spaces and special characters from a string

I use PurgeChar([Customer TOPS],' ,./-_+()£$!&*'), which is great.

But now I need to include the single quote as one of the chars to remove. I've tried square braces, using SET to create a variable, etc., but I just can't get the syntax right.

regards,

Marty.

Re: Purgechar syntax problem

qlikviewwizard — Tue, 21 Jul 2015 13:19:30 GMT

Hi MartynLloyd

Could you attach the sample application for better understanding and provide quick solution.

Thank you.

Re: Purgechar syntax problem

Kushal_Chawda — Tue, 21 Jul 2015 13:20:22 GMT

Instead of purge can you use keepchar()

for eg. if you want only numbers from string then use,

keepchar([Customer TOPS],'0123456789')

keepchar([Customer TOPS],'abcdefghijklmnopqrstuvwxyz')

Re: Purgechar syntax problem

sunny_talwar — Tue, 21 Jul 2015 13:24:46 GMT

For keeping letters, I would suggest a small edit:

KeepChar(Lower([Customer TOPS]), 'abcdefghijklmnopqrstuvwxyz')

Re: Purgechar syntax problem

Tue, 21 Jul 2015 13:37:40 GMT

Hi Martyn,

Try this

PurgeChar(PurgeChar([Customer TOPS],chr(39)),'./-_+()£$!&*')

Re: Purgechar syntax problem

Tue, 21 Jul 2015 13:38:19 GMT

Hi Martyn,

Try removing the ASCII value of apostrophe

PurgeChar(Lower(PurgeChar([Contractholder],' ,./-_+()£$!&*')),chr(39))