6 Replies Latest reply on Nov 5, 2018 1:12 PM by Matt Wilson

    Determine if string includes a letter

    Matt Wilson

      I need to exclude all strings in my dimension that contain a letter (A-Z). The below formula would work if I ran it all the way through Z, but I would like to find a simpler way.

       

      CONTAINS([Job (Sage)],'A') OR CONTAINS([Job (Sage)],'B')

       

      //then filter as false

       

      Thanks!