nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Jaz

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.

Accepted answers

Jeff_Perkinson

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

All comments

Jeff_Perkinson

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

Jaz

Thanks, much appreciated.

txnelson

.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

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

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