topic text to columns in JMP similar to excel in Discussions

text to columns in JMP similar to excel

narens13 — Thu, 01 Dec 2011 18:59:12 GMT

is there any way I can do text to columns in JMP as in excel

thanks

text to columns in JMP similar to excel

pmroz — Thu, 01 Dec 2011 19:52:16 GMT

If you are referring to Excel's ability to read in delimited text files, JMP can do the same thing. Click on File > Open and select Files of type: Text Files (*.txt; *.csv; *.dat; *.tsv). Your best bet is to use the option Data with preview. This will bring up a screen allowing you to specify all kinds of options, such as fixed width fields or delimited, the delimiter to use (if delimited fields), end of field character, etc.

text to columns in JMP similar to excel

narens13 — Thu, 01 Dec 2011 20:01:29 GMT

I want one column to be separated into two coulmns based on the delimiter

text to columns in JMP similar to excel

Jeff_Perkinson — Thu, 01 Dec 2011 21:54:18 GMT

Try this add-in.

Text to Cols

-Jeff

text to columns in JMP similar to excel

narens13 — Thu, 01 Dec 2011 21:58:32 GMT

is there anyway i can use the same functionality of this addin in JMP 8

text to columns in JMP similar to excel

Jeff_Perkinson — Fri, 02 Dec 2011 12:42:27 GMT

There'a .jmpmenu file version of it.

Make Columns from Text

It's a .jmpmenu file. You'll need to use Edit->Customize->Menus and Toolbars and then use the red triangle menu to "Import Menu Archive".

-Jeff

text to columns in JMP similar to excel

narens13 — Fri, 02 Dec 2011 15:06:00 GMT

When i insert the jmpmenu in JMP 8..i get the following error

Error in menu file. Error: Unable to insert into menu. Unable to find menu: EXTRAS

Thanks

text to columns in JMP similar to excel

Jeff_Perkinson — Fri, 02 Dec 2011 18:43:46 GMT

Sorry. I forgot that it relied on the Extras menu.

Here's the link for that:

Empty Extras Menu Archive

-Jeff