60656_en-US

liliconcom

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. 

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

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 !

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=""> " ) );</PATH></PATH>

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

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

Thanks, much appreciated. 

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.