A named argument that defines the type of resources that you want to close. The allowable types are: Data Tables, Reports, and Journals.
Copies files from one directory to another, optionally copying subdirectories. The directory name is created in the to path and should not be part of the to path argument.
Enable the user to select the data source, specify "Connect Dialog":
Returns a list of filenames in the path given.
List of filenames. If "recursive" is not specified, directory names are included in the list.
Retrieves the current directory, which is used in the Open File window. Note: The operating system can change the current directory outside of JMP.
‒
|
If JMP was opened using the JMP shortcut, the function returns the JMP Installation directory. For example, on Windows, the current directory is "/C:/Program Files/SAS/JMPPRO/<version>/" or "/C:/Program Files/SAS/JMP/<version>/".
|
‒
|
If JMP was opened by double-clicking a JMP file (.jmp, .jsl, .jrn, and so on), the command returns the path of the opened file.
|
‒
|
If the current directory was configured using the Set Current Directory() function, JMP returns the specified path.
|
If the default directory was set using Set Default Directory(), JMP returns the specified path as long as Get Default Directory() and Set Default Directory() are in the same script.
This list is configured using the Set File Search Path() function. See Set File Search Path({path or list of paths}).
Moves a file from the specified path to another specified path with the same or different file name.
Opens the data table or other JMP file or object created from a file named by the path. If no path is specified, the Open window appears. Refer to the examples in the JMP Scripting Index for details on which arguments apply to specific file types.
The available character set options for importing text files are "Best Guess", "utf-8", "utf-16", "us-ascii", "windows-1252", "x-max-roman", "x-mac-japanese", "shift-jis", "euc-jp", "utf-16be", and "gb2312".
‒
|
colName: Specifies the column name used in the imported text file.
|
‒
|
colType(Character | Numeric): Indicates whether the specified column contains character or numeric data.
|
‒
|
colWidth(n): indicates the integer width of the specified column.
|
For ESRI shapefiles (.shp), this argument and its settings indicate the following:
‒
|
Shape=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the shape number.
|
‒
|
Part=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the part number.
|
‒
|
X=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the decimal degree for the longitude (range of ±180°).
|
‒
|
Y=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the decimal degree for the latitude (range of ±90°).
|
If the imported text file uses an end of field character other than the one specified by End of Field, this argument specifies the character used.
If the imported text file uses an end of line character other than the one specified by End of Line, this argument specifies the character used.
An optional string that specifies the type of file that you are opening (for example, xls, bmp, jpg, or gif). If you do not specify this string, the file opens in the default program for the file type.
Note: The path argument should be used for a zip archive. The extension (.zip) is not required. See Zip Archives in JSL Messages for the messages that you can send to a zip archive. The basic functionality is to get a list of files in the zip archive, to read a file in the zip archive into either a string or a blob, and to write files into the zip archive. Note that reading a zip archive temporarily puts the contents into memory. Reading very large zip archives can cause errors.
Closes the specified JMP (.jrn, .jsl, .jrp, or .jmpappsource) file without saving and tries to reopen the file from disk. This argument deletes any changes made since the last time the file was opened.
To import a table from an HTML web page, use the URL as the filepath. This optional argument specifies which table number, n, on the web page to open. If you omit the value, only the first table on the page is imported.
Runs the specified JSL file instead of opening it. Include a Boolean argument or an expression that contains a Boolean value. If the script begins with //!, which automatically runs the script, include the Boolean value (0) to open the script instead.
Specifies the password for a password-protected Microsoft Excel .xls or SAS files to avoid entering it manually. The password is not encrypted. (Password-protected Microsoft Excel .xlsx files cannot be imported.)
If the fields in the text file are quoted, setting this to True removes the quotes, and setting it to False does not remove the quotes. The default value is True.
Indicates that JMP should use the Worksheets settings for all worksheets in the Excel file to be opened as a data table.
‒
|
Has Column Headers(Boolean) - Indicates the Excel file has column headers in the first row.
|
‒
|
Number of Rows in Headers(n) - Specifies the number of rows in the Excel file used as column headers.
|
‒
|
Headers Start on Row(n) - Specifies the row number in the Excel file where the column headers begin. Default is row 1.
|
‒
|
Data Starts on Row(n) - Specifies the row number in the Excel file where the data begins.
|
‒
|
Data Starts on Column(n) - Specifies the column number in the Excel file where the data begins.
|
‒
|
Data Ends on Row(n) - Specifies the row number in the Excel file where data ends.
|
‒
|
Data Ends on Column(n) - Specifies the column number in the Excel file where the data ends.
|
‒
|
Replicated Spanned Rows(Boolean) - Indicates the Excel file contains spanned columns that should be imported into JMP as spanned columns.
|
‒
|
Suppress Hidden Rows(Boolean) - Indicates that JMP should not import rows hidden in the Excel file.
|
‒
|
Suppress Hidden Columns(Boolean) - Indicates that JMP should not import columns hidden in the Excel file.
|
‒
|
Treat as Hierarchy(Boolean) - Indicates that JMP should treat multiple column headers (merged cells) as hierarchies when importing an Excel file. If True, the Excel file opens with the merged columns stacked (Tables > Stacked).
|
Opens the database indicated by connectInfo with the sqlStatement, returning a data table named outputTableName.
The following script assigns Select JMP File as the window title; shows the Documents directory; shows JMP Files and All Files in the File name list and selects JMP Files; displays the Open window; and shows the file name Earthquakes.jmp.
When you specify the new directory name, include only the directory name, not the entire path.
When you specify the new name, include only the file name, not the entire path.
Sets the current directory for Open File operations. Note: The operating system can change the current directory outside of JMP.
To avoid having to set the current directory for each file operation, define a filepath string and concatenate it with the filename. See the Path Variables section in the Scripting Guide for details.
Imports the specified Triple-S Survey (SSS) file. The SSS format consists of a pair of files: .xml or .sss, and a .csv, .dat, or .asc file. Both sets of files must have the same root name and be in the same folder.
Optional. Hides the table from view. The data table appears only in the JMP Home Window and the Window menu. Hidden data tables remain in memory until they are explicitly closed, reducing the amount of memory that is available to JMP. To explicitly close the hidden data table, call Close(dt), where dt is the data table reference returned by TripleS Import.