2 Replies Latest reply: Aug 3, 2011 2:20 PM by ggoyal_123 RSS

    not match, Not LIKE problem

      Hi All,

       

      This is a really small problem. I am trying to filter out these below names and get all other names, hence i have put a <> (not) sign. But still i get all these names. What is the mistake here?

       

      =if( SUBJECT_AREA <> 'Bop_Settlement'

      or SUBJECT_AREA <> 'Conf_Dim'

      or SUBJECT_AREA <> 'HODS_CTIX_DD'

      or SUBJECT_AREA <> 'Reporting'

      or SUBJECT_AREA <> 'WAR'

      or SUBJECT_AREA <> 'WebTrends' or wildmatch(SUBJECT_AREA,'CODS*')=0,SUBJECT_AREA)

       

      Thanks in advance!