Convert File Path(path, <"absolute"|"relative">, <"posix"|"windows">, <base(path)>)
Indicates whether to copy the from path subdirectory structure to the to path.
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 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.
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°).
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.
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.
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.