Subscribe Bookmark RSS Feed

Community Manager


Jun 23, 2011

Text to Columns, Version 3

Text to Cols JMP Add-In

Written by Jeff Perkinson


Version 3 now adds a callable JSL function. See Version notes below for details.




Text to Cols creates new columns from a column of delimited text. As shown above, the column “Data” has a comma-delimited string. Text to Cols creates the six new columns to the right.



After installing the Text to Cols add-in, you’ll find a new menu at the bottom of the Cols menu.


When you select this menu item, you’ll be prompted to choose a column of text and specify the delimiter.



Select your column and click OK.


New columns are added to the data table to contain the values from your column. Each new column has a formula using the Word() function to derive its value.




Version 2 updates


This version is built with the Application Builder. It uses a faster algorithm making it more efficient when dealing with lots of rows. It will also work on multiple columns at once.


Version 3 updates


Support for calling Text To Cols from JSL by adding a namespace with a function. column, delimiters, <data table=current data table()>)


   Creates new columns in data table from a column of text using delimiters to define each column



   An associative array
{{”columns”, list of columns created}, {”name”, text string with name of column group containing columns}}



column a JSL column reference of a text column to be split into multiple columns

delimiters a string of characters to be used as delimiters

data table optional reference to a data data table that column is in and to which should the new columns will be added. Current Data Table() will be used if no data table is specified.



bc_party = Open( "$SAMPLE_DATA\Consumer" ); Column( bc_party , "floss delimited"), ",", bc_party );




For help, comments, suggestions, questions, complaints or compliments, please email


Hi Jeff, I think it would be easy to add a modification to this to allow multiple columns to be selected to be run through the Text to Columns algorithm. Is this something you're interested in doing?

Good suggestion, mjoner.

I've updated the add-in to do support multiple columns.



Installed very easily, but nothing happens on my system when I click on the Text to Columns menu item.


I'm sorry for the difficulty. Rather than trying to debug it here in public I've sent you a direct message with some questions.

We can post back here once we figure out what's going wrong.



How can I get this add-in?


At the top there are two files attached. The second one *.jmpaddin needs to be saved somewhere. Open JMP and pick the file and drop it on a JMP window. JMP will ask you to install the add-in. Just follow the process and you shouldn't fail. If you want to read more about add-ins refer to the documentation within JMP under

Books -> Using JMP.pdf, search for JMP add-in or simply add-in.




Thank you very much.


Hi Jeff,

Thanks! The add-in works fantastically! Is there a function for this add-in that can be used in a script?



@Francisco, thanks for the comment. I've updated the add-in to Version 3 which includes a JSL function that you can call from your own script. Let me know how it works for you.

Article Labels
Article Tags