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

    Extract Filter: Including Values using "Contains"

    samhitha reddy



      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!