topic Check for non-alphanumeric characters in QlikView

Check for non-alphanumeric characters

Fri, 09 Oct 2009 23:15:45 GMT

Hello,

I am reading a single field from a table. I need to check if values in this field have any non-alphanumeric characters. If present, I need to flag it in a field indicating that there are non-alphanumeric characters in the corresponding row.

Thanks for your help

Check for non-alphanumeric characters

Sat, 10 Oct 2009 02:12:12 GMT

here's an example script:


load
 value,
 if(len(purgechar(value,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWYZ1234567890' ))>0,'NONALPHA','') as Flag
 inline [
value
abcdefghijklmnop
as2242w232342awer23
aasdasd?|||!!222asda
];

Check for non-alphanumeric characters

Sat, 10 Oct 2009 11:46:41 GMT

This is exactly what I was looking for. Thank you very much.