4 Replies Latest reply on Oct 7, 2016 9:33 AM by Stephen Crocker

    Filtering Out alpha in middle of a value

    Stephen Crocker

      I would like to know how to filter out of the data with a calculated column (can't change the SQL behind)

      I have a value 0e4902  I want to know how to filter this out or convert it to a null value

       

      I tried the following

      If CONTAINS([Field1],'[A-Z') then NULL

      Else [FIield1]

      End

      however this is not converting it.  is there another way to filter out A-Z in the middle of a field?