topic removing special chars in string in QlikView

removing special chars in string

Mon, 21 Apr 2014 07:27:18 GMT

Hi, I have data like this '290' and '9/454' and my output should be 290 and 9/454 INPUT '290' '9/454' OUTPUT 290 9/454 I tried using PURGE, KEEP CHAR functions but it seems not working. Pls let me know what is the right formula. Thanks,

Re: removing special chars in string

bumin — Mon, 21 Apr 2014 07:30:03 GMT

can you provide your qvw?

Re: removing special chars in string

its_anandrjs — Mon, 21 Apr 2014 07:35:39 GMT

use subfield function

Re: Re: removing special chars in string

Mon, 21 Apr 2014 07:40:32 GMT

Pls find the same. I am using personal edition

Thanks,

Re: removing special chars in string

its_anandrjs — Mon, 21 Apr 2014 07:41:11 GMT

Use this script

=mid(INPUT,2,len(INPUT)-2)

Re: removing special chars in string

its_anandrjs — Mon, 21 Apr 2014 07:43:50 GMT

Use this script for new list box

=mid(Text,2,len(Text)-2)

Re: removing special chars in string

its_anandrjs — Mon, 21 Apr 2014 07:45:17 GMT

Load your table like this

LOAD * INLINE [

Text

"'290'"

"'9/454'"

];

LOAD

Text,

Mid(Text,2,len(Text)-2) as NewText // You get this new field

Resident T;

Re: removing special chars in string

anbu1984 — Mon, 21 Apr 2014 07:47:15 GMT

To remove single quotes try this

Replace(Input_Field,Chr(39),'')

Re: removing special chars in string

jagan — Mon, 21 Apr 2014 07:49:09 GMT

Hi,

Try like this

LOAD * ,

Text(Replace(Text, chr(39), '')) as modified

INLINE [

Text

"'290'"

"'9/454'"

];

Regards,

Jagan.

Re: removing special chars in string

Mon, 21 Apr 2014 07:53:54 GMT

Please find attachment.

Re: removing special chars in string

arjunkrishnan — Mon, 21 Apr 2014 08:01:16 GMT

Hai Frd

I Just try This One ..Lets Try This One

T1:

LOAD * INLINE [

name gard

'290' and '9/454'

'291' and '10/454'

'292' and '11/454'

];

T2:

LOAD *,[name gard] as INPUT,

keepchar ( [name gard] ,0123456789 )as TEST1,

purgechar([name gard],' '' ') as TEST2 Resident T1;

T3:

LOAD left(TEST2,3)&Chr(32)&Mid(TEST2,4,3)&Chr(32)& right(TEST2,6)as OUTPUT Resident T2;

My Out Put Like That