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
You can do this kind of thing with column formulae. However, I find it best to use the Recode platform. I suggest that you look at the help documentation. In particular Advanced > Extract Segment.