topic Re: Removing Special characters and numbers from string? in QlikView

Removing Special characters and numbers from string?

Anonymous — Sun, 06 Jul 2014 18:35:36 GMT

"'$'Venkat40!23# " how can i get only 'venkat' from that string?

I used Keepchar('$'Venkat40!23#','ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz').it is giving output but i m looking for better solution.

Thanks in Advance

Re: Removing Special characters and numbers from string?

swuehl — Sun, 06 Jul 2014 19:59:40 GMT

There is also PurgeChar() function, if this is any better.

Re: Removing Special characters and numbers from string?

jagan — Mon, 07 Jul 2014 02:15:41 GMT

Hi,

Try like this

=KeepChar('$Venkat40!23#', 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

Regards,

Jagan.

Re: Removing Special characters and numbers from string?

Anonymous — Mon, 07 Jul 2014 03:37:19 GMT

Thanks Swuehl..

Re: Removing Special characters and numbers from string?

Anonymous — Mon, 07 Jul 2014 03:40:15 GMT

Thanks Jagan...I tried that function and i am getting the result but i m trying to avoid to write "'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'" this much of string.

Re: Removing Special characters and numbers from string?

jagan — Mon, 07 Jul 2014 03:56:54 GMT

Hi Venkat,

I think this is the best option, you declare a variable and use it in the expression

vAlphabets = ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz

=KeepChar('$Venkat40!23#', vAlphabets)

Regards,

Jagan.

Re: Removing Special characters and numbers from string?

Anonymous — Mon, 07 Jul 2014 04:07:49 GMT

Ya we can do like that but for only one string its not good to have variable i think. thank u Jagan...

Re: Removing Special characters and numbers from string?

jagan — Mon, 07 Jul 2014 05:29:02 GMT

Hi Venkat,

Yes, as far I know this is the solution, we have to go like this.

Regards,

Jagan.