Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Jaz
Jaz
Level V

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
Highlighted
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
Highlighted
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

Highlighted
Jaz
Jaz
Level V

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

Thanks, much appreciated. 

Highlighted
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
Highlighted
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 !

Highlighted
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

Article Labels

    There are no labels assigned to this post.