cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
SpannerHead
Level VI

Selectively import CSV files based on content.

I have built a script based on the information I found in this post.

 

Solved: Re: Open Multiple Data Files Recursively - JMP User Community

 

Great suggestions in there.  The remaining difficulty I have is that the finally assembled file is very large and I wind up throwing much of it away because it is not relevant.  This is probably a stretch but can JMP select CSV files based on their content before importing to avoid importing first and then eliminating the ones that don't apply.  Something along the lines of If(Contains.......... applied to the source CSV file while the file is not yet imported?


Slán



SpannerHead
1 REPLY 1
jthi
Super User

Re: Selectively import CSV files based on content.

You can load the csv as JMP table, if it doesn't pass your checks ignore that table. Or load csv as text, perform checks, if checks are ok then open it as table (or convert the text to table).

-Jarmo

Recommended Articles