cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

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