topic Re: Remove spl characters in QlikView

Remove spl characters

prma7799 — Tue, 20 Jan 2015 04:50:55 GMT

Hi All,

How to remove below special characters from backend and frontend .

*1415*4052

*4372

``AH030910WPI00906

`AH030809WPI00578

`SU020708WIN00999

`TT021213WIN00795

`TT030708WIN01021

`TT031011WPI01399

thanks

Re: Remove spl characters

prma7799 — Tue, 20 Jan 2015 05:19:33 GMT

any idea...

Re: Remove spl characters

Tue, 20 Jan 2015 05:29:27 GMT

hi Prashantbi,

Try using Apply map and MapSubString.

Please let me know if u need help on this.

Regards,

Pavan.

Re: Remove spl characters

jagan — Tue, 20 Jan 2015 05:30:41 GMT

Hi,

Try Keepchar()

Example: KeepChar(DimName, '1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')

-- If you want to retain only numbers and alphabets.

Or Purgechar()

Example: Purgechar(DimName, '*~')

-- This will remove * and ~ from your dimension value.

Hope this helps you.

Regards,

Jagan.

Re: Remove spl characters

its_anandrjs — Tue, 20 Jan 2015 05:34:21 GMT

Hi,

Try Purgechar or Keepchar

Ex:-

LOAD PurgeChar(Chars,'*`~' ) as NewChar,*;
LOAD * Inline
[
Chars
*1415*4052
*4372
`
``
``AH030910WPI00906
`AH030809WPI00578
`SU020708WIN00999
`TT021213WIN00795
`TT030708WIN01021
`TT031011WPI01399
~~

];

Regards

Anand

Re: Remove spl characters

prma7799 — Tue, 20 Jan 2015 05:34:46 GMT

Hi Anand,

I want to remove ' '' this character also

Thanks

Prashant

Re: Remove spl characters

jagan — Tue, 20 Jan 2015 05:41:02 GMT

Hi Prashant,

Then try like this

=Purgechar(DimName, '*~' & chr(39))

Hope this helps you.

Regards,

Jagan.

Re: Remove spl characters

its_anandrjs — Tue, 20 Jan 2015 05:43:34 GMT

Hi,

Then use ascii char of the character and use CHR() function in transformation step

Ex:-

LOAD *,PurgeChar(SecondPurgeChar,Chr(34)) as ThirdPurgechar;
LOAD *,PurgeChar(NewChar,Chr(96)) as SecondPurgeChar;
LOAD
PurgeChar(Chars,'*`~' ) as NewChar,*;
LOAD * Inline
[
Chars
*1415*4052
*4372
`
``
``AH030910WPI00906
`AH030809WPI00578
`SU020708WIN00999
"
""
,
`TT021213WIN00795
`TT030708WIN01021
`TT031011WPI01399
~~

];

Regards

Anand

Re: Remove spl characters

deepakqlikview_123 — Tue, 20 Jan 2015 06:35:45 GMT

Use string functions.

Re: Remove spl characters

prma7799 — Tue, 20 Jan 2015 07:04:29 GMT

Hi Jagan,

I used

=PurgeChar(INVC_LABEL,'~*`''')

but now I want that remove any special character from the above mean in future user insert data with another spl character then what will I do..

Thanks

Prashant

Re: Remove spl characters

jagan — Tue, 20 Jan 2015 07:08:16 GMT

Hi,

If you want to remove any another special character then add those in the second parameter or you can use Keepchar(). Given example in the first thread.

Regards,

Jagan.

Re: Remove spl characters

prma7799 — Tue, 20 Jan 2015 08:32:06 GMT

Thanks Jagan....