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
Great suggestions in there. The remaining difficulty I have is that the finally assembled file is very large and I wind up throwing much of it away because it is not relevant. This is probably a stretch but can JMP select CSV files based on their content before importing to avoid importing first and then eliminating the ones that don't apply. Something along the lines of If(Contains.......... applied to the source CSV file while the file is not yet imported?
You can load the csv as JMP table, if it doesn't pass your checks ignore that table. Or load csv as text, perform checks, if checks are ok then open it as table (or convert the text to table).
