topic Re: Special Characters Restriction in QlikView

Special Characters Restriction

adnan_rafiq — Tue, 11 Jul 2017 04:35:16 GMT

Hi Experts,

I have a situation in which I have a column with descriptions, the problem is that if any of the special characters (that is any character other than 0 to 9, a to z , A to Z) are contained in it. I want to mark it.

The problem is tried looping through each value character by character , it becomes too much time taking. I have about 20K values.

Description	I want mark
Hello	OK
Hello)hi	Bad
Bye	OK
Bye's	Bad

All suggestion and help much appreciated , Especially from

stalwar1‌

Re: Special Characters Restriction

Anil_Babu_Samineni — Tue, 11 Jul 2017 04:48:59 GMT

May be this? If you have counted the different strings that may useful to use with PurgeChar()

LOAD Description, If(SubStringCount(KeepChar(Description,'0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'),Description), 'OK', 'Bad') as [I want Mark] Inline [

Description

Hello

Hello)hi

Bye

Bye's

];

Re: Special Characters Restriction

adnan_rafiq — Tue, 11 Jul 2017 05:05:33 GMT

This seem fine, now a small complication what if I want to OK to some description that has single quote (')?

Re: Special Characters Restriction

Muthu — Tue, 11 Jul 2017 05:27:14 GMT

Hi,

Please find the attached qvw. Hope this helps

Re: Special Characters Restriction

Anil_Babu_Samineni — Tue, 11 Jul 2017 05:28:31 GMT

Haha, There is no such escape sequence in qlikview. But, Work around this?

LOAD Replace(Description, '%', Chr(39)) as Desciption,

If(SubStringCount(KeepChar(Description,'0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ%'),Description), 'OK', 'Bad') as [I want Mark];

LOAD Replace(Description, Chr(39), '%') as Description Inline [

Description

Hello

Hello)hi

Bye

Bye's

];

Note - If you ask in your data has % as well. Then i suggest you to done where different character like Circle or Square ....