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

Question

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!

jthi · Accepted Answer

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.