BookmarkSubscribeRSS Feed
laura_archer

Staff

Joined:

Aug 7, 2015

Solution

Re: How to split a column cells into different columns

If you're using JMP 12 or later you can use Cols -> Utilities -> Text to Columns.

 

12569_JMPScreenSnapz034.png

 

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, ", " )

 

 

12570_JMPScreenSnapz035.png

ENTHU

Contributor

Joined:

May 13, 2018

Re: How to split a column cells into different columns

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

 

txnelson

Super User

Joined:

Jun 22, 2012

Re: How to split a column cells into different columns

Take a look at the Word() function and the Substr() function. And you could also use a regular expression with Regex() function
Jim