5 Replies Latest reply: Feb 20, 2013 5:28 AM by ealmeidasc RSS

Detecting non-alphanumeric characters

ealmeidasc

Hi,

 

I am using

 

len(purgechar(fieldname, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890'))

 

to flag an error if there are anything apart from letters or numbers in the field.

 

However, if I set the above expression >0 it flags all the fields as an error. If I set it >1 it miss out on fields that ONLY contain special characters.

 

Does anyone know what I am doing wrong? Has anyone had this error before?

 

Cheers