Special Characters Restriction

[adnan_rafiq]

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‌

[Anil_Babu_Samineni]

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

];

[adnan_rafiq]

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

[Muthu]

Hi,

Please find the attached qvw. Hope this helps

[Anil_Babu_Samineni · Accepted solution]

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 ....