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

Detecting non-alphanumeric characters




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?