- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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).