Rename column heading for multiple JMP files

tejvishnu

Hello,

I have about more than 200 JMP files in a directory and all of them have the same column headings. I realized that there is a typographical error for one of the column headings and I was wondering if there is a simple way to correct this for each of these 200 files.

Thanks

txnelson

JMP has a fairly extensive set of functions that allow for file manipulations.  They are well documented with examples at:

     Help==Scripting Index==>Functions==>File

Here is a real simple script that does what you are requesting

Names Default To Here( 1 );
Thefiles = Files In Directory( "C:\Users\txjim\Documents\test files" );
For( i = 1, i <= N Items( TheFiles ), i++,
	dt = Open( "C:\Users\txjim\Documents\test files" || "\" || TheFiles[i] );
	dt:sex << set name( "Gender" );
	Close( dt, save );
);