topic Re: script for opening txt file in Discussions

script for opening txt file

wongpl — Thu, 17 Mar 2011 04:23:16 GMT

i always need to open report file ( xxx.rpt) which store in text form in text delimitted form.

i can use the jmp to import the file into jmp table, but the process is a bit tedious.

here is what i do,
1) click " Open data table"
2) type in "*.*" in file name to show all file
3) select the report file that i need ( report file ending with .rpt )
4) change the file type to txt
5) select the option of " Data with preview" click open
6) new window pop up, i select these setting, delimited fileds, end of field is comma, file contains column names on line is 29 , data starts on line 30.
7) click "next"
8) click " import"

i need a scrip that can automate this process. i need a scrip to select the file , then click open to import the file.
i have look thru the Jmp scripting guide but fail to write it.

Re: script for opening txt file

pmroz — Thu, 17 Mar 2011 13:18:04 GMT

Once you have opened a file, click on the little red triangle next to the word Source in the upper left corner. Select Edit, and copy the code. Then, combine this code with the pick file() function:

Here's an example I worked up where I saved Big Class.jmp as a csv file with the extension .rpt

my_file = pick file({"All files|*"});

my_dataset = open(my_file,
columns(
name = Character,
age = Numeric,
sex = Character,
height = Numeric,
weight = Numeric
),
Import Settings(
End Of Line( CRLF, CR, LF ),
End Of Field( Tab, Comma ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Scan Whole File( 1 ),
Labels( 1 ),
Column Names Start( 1 ),
Data Starts( 2 ),
Lines To Read( All ),
Year Rule( "10-90" )
)
);

Re: script for opening txt file

wongpl — Tue, 22 Mar 2011 00:23:59 GMT

Thanks you..PM roz, this fix the problem. Excellent