2 Replies Latest reply on Jun 21, 2016 3:37 PM by samhitha reddy

    Extract Filter: Including Values using "Contains"

    samhitha reddy

      Hello,

       

      I'm trying to add a filter to data extraction.

       

      I want the filter to include only values which  contain "PT-"  or  which contains "PW-" in the string.

       

      I've tried this formula in filter:

       

      Contains([field name],'PT-') or Contains ([Field name],'PW-')

       

      then it is returning zero records even though it contains many with (PT-) or (PW-).

       

      how can i correct this formula and get whatever is needed?

       

      Any ideas on what I'm missing here? Thanks!

       

      Samhitha