Hello, I've replied to a thread and my replies keep on being removed. They've been marked as spam for some reason. I'm including some JSL code. Perhaps that's why?
Link to post:
(Re: Multiple File Import, file filtering)
by StarfruitBob
https://community.jmp.com/t5/Discussions/Multiple-File-Import-file-filtering/m-p/485471#M72939
Hello jthi, My previous reply seems to have vanished for some reason. I'm playing around with Contains() and as soon as I add this into the query, it keeps on looping and never actually imports the data. Any idea? Here's the script. Multiple File Import( <<Set Folder( "C:\Data"), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Set Name Filter( "*.csv; " ), <<Set Name Enable( 1 ), <<Set Size Filter( {456, 1862046} ), <<Set Size Enable( 0 ), <<Set Date Filter( {3734756690.048, 3734950423.726} ), <<Set Date Enable( 0 ), <<Set Add File Name Column( 1 ), <<Set Add File Size Column( 0 ), <<Set Add File Date Column( 0 ), <<Set Import Mode( "CSVData" ), <<Set Charset( "Best Guess" ), <<Set Stack Mode( "Stack Similar" ), <<Set CSV Has Headers( 1 ), <<Set CSV Allow Numeric( 1 ), <<Set CSV First Header Line( 1 ), <<Set CSV Number Of Header Lines( 1 ), <<Set CSV First Data Line( 2 ), <<Set CSV EOF Comma( 1 ), <<Set CSV EOF Tab( 0 ), <<Set CSV EOF Space( 0 ), <<Set CSV EOF Spaces( 0 ), <<Set CSV EOF Other( "" ), <<Set CSV EOL CRLF( 1 ), <<Set CSV EOL CR( 1 ), <<Set CSV EOL LF( 1 ), <<Set CSV EOL Semicolon( 0 ), <<Set CSV EOL Other( "" ), <<Set CSV Quote( "\!"" ), <<Set CSV Escape( "" ), <<Set XML Method( "guess" ), <<Set XML Guess( "huge" ), <<Set XML Settings( XML Settings() ), <<Set JSON Method( "guess" ), <<Set JSON Guess( "huge" ), <<Set JSON Settings( JSON Settings() ), <<Set Import Callback( Empty() ), <<!Contains(part, "Tomato"), <<Contains(part, "Apple") ) << Import Data
This message has 0 replies
