If you're using JMP 12 or later you can use Cols -> Utilities -> Text to Columns.
If you're using JMP 11 or earlier you can get the add-in, Text to Columns, Version 2, which does the same thing as the now, built-in function.
If you want to do this by hand, either with JSL or the Formula Editor, you'll find the Word() function handy, as described by thechadd
Last Name: Word( 1, :Name, ", " )
First Name: Word( 2, :Name, ", " )
Looking for an extension of Text to Columns/Word function.I have a path in a column -
Z:\abc\def\foldername\filefolder\filename.
I need to extract 3 things from this path -
1.foldername
2.Path until file folder
3.file name
I am basically getting this data from data base.Need to post process it and fill an excel template.
I tried text to columns;going through multiple iterations will get me there but its very inefficient.
Looking for recommendation.
Thanks