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

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

Jaz — Wed, 20 Jun 2018 12:31:17 GMT

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

Jeff_Perkinson — Wed, 20 Jun 2018 12:38:23 GMT

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

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

Jaz — Wed, 20 Jun 2018 12:47:40 GMT

Thanks, much appreciated.

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

txnelson — Wed, 20 Jun 2018 12:53:27 GMT

.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

Help==>Books==>Scripting Guide

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

AY — Wed, 17 Apr 2019 07:29:12 GMT

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

AY — Wed, 17 Apr 2019 07:29:38 GMT

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