cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
SpannerHead
Level IV

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