Data analysis on multiple text files?

newjmpuser

Hi,

I am a new jmp user and was wondering if there is a way to script the following.

     1) open all text files from a folder

     2) determine min and max of a certain column (lets say coloumn 2).

     3) store the min and max data in another jmp table with respect to the text file names.

thanks for any help i can get..

unknown

I've written a little script that should do this: it could do with an error-trap to check for text files that don't have at least three columns, and you'll need to change the default directory at which it looks initially for .txt files, but essentially I think it should do what you need - or at least provide you with a starting point that you can customize further.  Would you like to give it a try?

Cheers,

David

Document3.txt.zip

Script1.jsl.zip

Document2.txt.zip

Document1.txt.zip