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.