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

[#1]

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. 

[#2 · Accepted solution]

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

[#3]

Thanks, much appreciated. 

[#4]

.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

[#5]

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

[#6]

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