Check for non-alphanumeric characters

[#1]

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

[#2]

here's an example script:

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

[#3]

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