Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- text to columns in JMP similar to excel

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

Dec 1, 2011 10:59 AM
(1975 views)

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

thanks

7 REPLIES 7

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

**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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

There'a .jmpmenu file version of it.

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

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

text to columns in JMP similar to excel

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

Here's the link for that:

-Jeff

-Jeff