select where contains & !contains

wjalford — Mon, 18 Feb 2019 03:41:23 GMT

I need to select rows that contain lot number that start with 8 but do not have Lot in them. Example 81234 should be selected but 82134 - Lot should not be selected.

dt1 << Select where ((Contains(dt1, "Lot Number"),"8") & (!Contains(dt1, "Lot Number"),"Lot"));

This does not work. Does anyone know how I can exclude rows that have the word Lot in the cell Lot Number. The cell is Lot Number an example is 81333 - Lot.

Re: select where contains & !contains

txnelson — Mon, 18 Feb 2019 04:06:33 GMT

dt1 << Select where (Contains(:Lot Number,"8") == 1  & Contains(:Lot Number, "Lot" ) == 0 )

topic select where contains & !contains in Discussions

select where contains & !contains

Re: select where contains & !contains