User Community
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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (1487 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 (1485 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 (1486 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

Recommended Articles