topic Re: Special character removal in QlikView

Special character removal

Mon, 11 Mar 2013 14:50:19 GMT

Hi-Can someone please help me on this? I need to remove multiple special characters from a string field.Example

a#riz'ona!

&vir$gin-ia

*flori&da1@

Result should be

arizona

virginia

florida

Thanks,Pooja

Re: Special character removal

jagan — Mon, 11 Mar 2013 14:53:12 GMT

Hi,

Try using Keepchar()

KeepChar(s1 , s2)

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

Example:

keepchar ( 'a#riz'ona!','abcdefghijklmnopqrstuvwxyz' ) returns 'arizona'

Hope this helps you.

Regards,

Jagan.

Re: Special character removal

swuehl — Mon, 11 Mar 2013 14:53:40 GMT

Try using keepchar or purgechar functions, like

purgechar('&vir$gin-ia','&$-')

Re: Special character removal

Mon, 11 Mar 2013 14:59:26 GMT

Thanks..but with purgechar, I have to include all the special characters because for each row the string has different specia characters.

Re: Special character removal

Anonymous — Mon, 11 Mar 2013 15:04:40 GMT

keepchar works if you have your fields in a column , attached a file.

Re: Special character removal

jagan — Mon, 11 Mar 2013 15:06:37 GMT

Hi Pooja,

Try with KeepChar function,

=keepchar ( 'a#riz'ona!','abcdefghijklmnopqrstuvwxyz' ) returns 'arizona'

Hope this helps you.

Regads,

Jagan.

Re: Special character removal

Thu, 26 Feb 2015 07:50:59 GMT

Hi jagan..

In my data i have single Quotes in All the Rows how can remove it in backend..i wil load all the fields using Load * from....So in that hw can i remove...

Re: Special character removal

jagan — Thu, 26 Feb 2015 10:01:13 GMT

Hi,

Try to use PurgeChar() like below

PurgeChar(FieldName, Chr(39))

Regards,

Jagan.

Re: Special character removal

Thu, 26 Feb 2015 12:09:19 GMT

i was just taking All the fields i am havng more than 50 fields....So is that any way to remove using loop or anything..