cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Jaz
Jaz
Level IV

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

Hi, 

 

This must be a very simple question but there is a lack of documentation so I was struggling with how to import CSV files into JMP and save them as data tables? 

 

Any help would be appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

The Import Text Files section of Using JMP explains how to use File->Open to import text files, including .CSV files.

-Jeff

View solution in original post

5 REPLIES 5
Jeff_Perkinson
Community Manager Community Manager

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

The Import Text Files section of Using JMP explains how to use File->Open to import text files, including .CSV files.

-Jeff
Jaz
Jaz
Level IV

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

Thanks, much appreciated. 

txnelson
Super User

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

.csv files are opened directly in JMP.  They are treated as just another file to open.  So if you are running interactively, you just go to

     File==>Open

and then navigate to the .csv file you want to open, and then open it

To save it as a JMP file, just go to

     File==>Save As

 

In JSL the following is the code:

Names Default To Here( 1 );
dt = Open( "<path and file name.csv>" );
close( dt, save( "<path and file name.jmp> " ) );

Documentation for the interactive open and save is in

     Help==>Books==>Using JMP

Documentation for the JSL is in

     Help==>Scripting Index

or

     Help==>Books==>Scripting Guide

Jim
AY
AY
Level II

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

Been scrolling for hours to find this kind of solution. Thanks @txnelson !

AY
AY
Level II

RE: Importing a CSV File Into JMP & Turning it Into a Data Table

Been scrolling for hours to find this kind of solution. Thanks @txnelson