cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Crish42
Crish42
Level I

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

Jul 23, 2024 09:54 AM (398 views)

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User jthi
Super User
Solution

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

Jul 23, 2024 10:02 AM (396 views)  |  Posted in reply to message from Crish42 07-23-2024

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 jthi
Super User
Solution

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

Jul 23, 2024 10:02 AM (397 views)  |  Posted in reply to message from Crish42 07-23-2024

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