cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Crish42
Level I

Import data from csv file when given the lower and upper bounds

I have csv files exported from Instron (data.csv), and I'd like to import the data from one column given the lower and upper bounds specified for another column. I have an image below that demonstrates what I'm interested in. I have values in B1 and B2 that specify the lower and upper bounds of the data from column A (between A12 and A33). I want to write a script in JMP that extracts the corresponding data from row C (between C12 and C33) that matches the values in column A. Any help would be appreciated. Thank you!

Instron data.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Import data from csv file when given the lower and upper bounds

Do two exports, one for the limits (this could be just as text if you want to or table as it is easier to use) and one for the date. Then get the limits, create a comparison to select the rows based on the limits, invert selection and delete the rows you aren't interested in. And finally remove the columns you don't need.

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Import data from csv file when given the lower and upper bounds

Do two exports, one for the limits (this could be just as text if you want to or table as it is easier to use) and one for the date. Then get the limits, create a comparison to select the rows based on the limits, invert selection and delete the rows you aren't interested in. And finally remove the columns you don't need.

-Jarmo