topic Re: Selecting only csv files using jsl in Discussions

Selecting only csv files using jsl

vharibal — Sat, 02 Nov 2024 07:15:39 GMT

Hi,
I have folder with multiple folders and csv files. I would like to open only csv files and concatenate them without opening folders

I tried using Files in Directory function and opening files from folder but this opens the folders as well

Can some one please help me on this?

Re: Selecting only csv files using jsl

txnelson — Sat, 02 Nov 2024 09:34:12 GMT

You can easily filter the list of files returned from Files in Directory, to return only .csv files

Names Default To Here( 1 );
files = Files In Directory( "C:\Program Files\JMP\JMPPRO\18\Samples\Import Data", recursive( 0 ) );
onlycsv = Filter Each( {x}, files, contains(x,".csv"));

You may also want to look into using Multiple File Import. If your .csv files are similar MFI can automatically concatenate them for you

Names Default To Here( 1 );

mfi = Multiple File Import();
mfi << Set Folder( "$SAMPLE_IMPORT_DATA" );
mfi << Set Name Filter( "*.csv" );
mfi << Set Name Enable( 1 );
mfi << Set Stack Mode( "Stack Similar" );
mfi << Set Subfolders( 0 );
tables = mfi << Import Data();

Re: Selecting only csv files using jsl

vharibal — Tue, 05 Nov 2024 04:53:24 GMT

Thank you so much.

It worked.