cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
wjalford
Level III

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.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: select where contains & !contains

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

View solution in original post

1 REPLY 1
txnelson
Super User

Re: select where contains & !contains

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