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; } } }

Import .dif file format in JMP Script

JensRiege

I am trying to import a .dif text file into a JMP data table.

When I use the file import, I have the option of using Excel to open it, or "Data with Preview".

If I were to write a script to use Excel to open it, how do I get the same script to put the excel worksheet into a JMP table for further use.

I would prefer not to have to use an external program to open it, but if I use Data with Preview, it puts all data into just one column in the .dif file format structure:

Header 1

Value1, Value 2

Header 2

Value3, Value 4,

etc.

Is there a way for JMP to open .dif files directly in the same table structure that Excel creates?

Thank you for any help you can provide.

Jens

Accepted answers

stan_koprowski

Hi @JensRiege ,

I created an add-in to import data interchange format (DIF).

Have a look and let me know if this will work for your files.

cheers,

Stan

All comments

cwillden

Maybe you could parse it if you read it in as plain text? I'm not sure what the file contents look like in a dif file.

JensRiege

Thanks for replying cwillden.

Attached are what the file looks like if I try to open it in Plain text format and with "Data Using Text Import Preferences"

All text is in column 1 in separate rows, and numbers are in first and second column) Plain Text.png Data Using Text Import Preferences.png

Data Using Text Import Preferences.png

Plain Text.png

stan_koprowski

Hi @JensRiege ,

I created an add-in to import data interchange format (DIF).

Have a look and let me know if this will work for your files.

cheers,

Stan

JensRiege

Replied privately, but wanted to make sure this forum got the feedback. Solution works very well. I modified the Add-in to allow the code to be used within a JMP script file. I am using this code daily now for production requirements. Thank you!