Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
For columns which are non-multiple-response, is it possible to set up such negative selections as well? I mean: directly via the data filter logics, not via select and invert. Just putting the "Match none" around a standard filter did not work ...
If this is not possible yet for standard coulumns, I will write a wish ... it's so useful to have the possibility to negate selections ...
For "multiple response" there is no problem to add the column twice to the data filter. For standard columns, JMP will just refuse to add another copy.
But one can enable "grouped by and" to get the same column twice
So, what's missing to get THIS, but not THAT data filters for standard columns: