113950_en-US

liliconcom

select where contains & !contains

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

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