https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710718#M14570 Hi nigel, it works! Thank you very much. I thought the AND operator works<BR />only if warden and EMSC are in the same title, but i want to exclude titles<BR />that contain either or.<BR />Wow seems like rule for inclusion and exclusion interpret the operators<BR />differently. Mind boggling!<BR /> Tue, 12 Jan 2021 01:31:00 GMT mattneo 2021-01-12T01:31:00Z https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710542#M14566 <P>1</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 27 Mar 2021 13:43:48 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710542#M14566 mattneo 2021-03-27T13:43:48Z https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710548#M14567 <P>You need the AND operator rather than OR with NotContains. You want records where the field doesn't contain "warden" AND doesn't contain "EMSC". One of those things where boolean logic doesn't match normal grammatic sense in English.</P> <P>&nbsp;</P> <P>Incidentally, I notice that in the case of "warden" you are upper-casing the field and then searching for the lower-case text, so that won't exclude any records.</P> Mon, 11 Jan 2021 14:25:39 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710548#M14567 Nigel_Pain 2021-01-11T14:25:39Z https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710718#M14570 Hi nigel, it works! Thank you very much. I thought the AND operator works<BR />only if warden and EMSC are in the same title, but i want to exclude titles<BR />that contain either or.<BR />Wow seems like rule for inclusion and exclusion interpret the operators<BR />differently. Mind boggling!<BR /> Tue, 12 Jan 2021 01:31:00 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710718#M14570 mattneo 2021-01-12T01:31:00Z https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710744#M14571 <P>Glad that's sorted. Please mark it as solved.</P> Tue, 12 Jan 2021 08:52:52 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Text-input-at-Page-control-in-SAS-VA-8-3-1/m-p/710744#M14571 Nigel_Pain 2021-01-12T08:52:52Z