topic How do you open multiple files and specify what the column names are for the files? in Discussions

How do you open multiple files and specify what the column names are for the files?

tsolomon — Thu, 29 Oct 2015 02:30:05 GMT

I found this script which opens multiple files but the columns in the files don't have a header and this script automatically converts the first row into column names. Do you know how to modify this to specify the first row is not the column names and specify the column names for each file if the names are all the same?

Re: How do you open multiple files and specify what the column names are for the files?

tsolomon — Thu, 29 Oct 2015 02:32:06 GMT

Here is the script to open multiple files that I found on another posting.

Set Default Directory( "C:\Jan_24th\" );

files = Files In Directory( "C:\Jan_24th\" );

For( i = 1, i <= N Items( files ), i++,

If( Ends With( files[i], ".csv" ),

Open( files[i] );

Text Box( Regex( files[i], "(.+?)_", "\1" ) ) << journal; // All text before first "_" in file i's name is journaled

)

);

Re: How do you open multiple files and specify what the column names are for the files?

msharp — Wed, 19 Oct 2016 01:04:05 GMT

This is a JMP preference. Go to File >> Preferences (ctrl+k) and uncheck the box.

Similarly you can can script this with:

Set Preferences(Import Settings(Labels(0))) //off

Set Preferences(Import Settings(Labels(1))) //on

Be sure to turn the preference back on when you are done or else you are going to annoy your end user.

Re: How do you open multiple files and specify what the column names are for the files?

ian_jmp — Thu, 29 Oct 2015 14:54:33 GMT

The 'Open()' command is very versatile, so has many options. Select 'Help > Scripting Index', type 'Open' in the search field at the upper left, and look for 'Open()' in the Items list. You can then inspect and run some examples. Example 2 contains the option 'Table Contains Column Headers( 0 )' which seems to be what you want.

Re: How do you open multiple files and specify what the column names are for the files?

tsolomon — Thu, 29 Oct 2015 17:47:22 GMT

Thank you, this worked great!