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