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?