New to JMP? Let the Data Analysis Director guide you through selecting an analysis task, an analysis goal, and a data type. Available now 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.