Convert File Path(path, <"absolute"|"relative">, <"posix"|"windows">, <base(path)>)
Indicates whether to copy the from path subdirectory structure to the to path. On Windows operating systems released after Windows XP, copying is always done recursively.
Create Database Connection( "dsn=Books;UID=johnsmith;password=Christmas" );
Create Database Connection( "dsn=Books;UID=johnsmith", Driver Prompt( 1 ) );
Create Database Connection( "Connect Dialog" );
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. The function is deprecated. On Macintosh and Windows, the initial current directory is the user’s Documents folder. Previously, Windows returned the folder that contained jmp.exe or the working folder set by the operating system when JMP is launched.
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.
The function supports .xlsx and Excel 1997 or later workbooks.
Reads the text file at path into a JSL variable.
"best guess" attempts to detect the character set.
force("throw"|"alert"|"silent") is an optional argument that determines what happens if the character set cannot be detected.
Optional argument that specifies the end-of-line character. For example, "\!n" specifies a line feed character. "\!t" specifies a tab.
ReadOffsetFromBegin(n) specifies the zero-based offset to begin reading from the beginning of the file.
ReadOffsetFromEnd(n) specifies the zero-based offset to begin reading from the end of the file.
ReadLength(n) specifies the number of bytes to read from the file, either from the beginning of the file or from one of the offset values.
Base64Compressed(0|1) specifies how the blob is converted to a printable representation. 0, the default and recommended setting, uses JMP’s ASCII~HEX representation. 1 means the blob is compressed and converted to base 64 when printed.
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. Also opens JSON and HDF5 files. Refer to the examples in the JMP Scripting Index for details about 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. The optional n 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. The optional ColumnNames(n) specifies the row that contains column names. The optional DataStarts(n) specifies the row on which the data begins.
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.
path An optional quoted string that specifies the initial directory that appears in the Pick Directory window.
Show Files (Boolean) Specify 1 to show files in the Pick Directory window, or zero to hide files. The default is zero.
The following script assigns Select JMP File as the window title; shows the JMP Samples/Data directory; shows JMP Files and All Files in the File name list and selects JMP Files; displays the Open window; and shows the sample data file name Hollywood Movies.jmp.
Pick File(
	"Select JMP File",
	"$SAMPLE_DATA",
	{"JMP Files|jmp;jsl;jrn", "All Files|*"},
	1,
	0,
	"Hollywood Movies.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. The function is deprecated. Setting the current directory saves or returns the new value for backwards compatibility though the value is not used.
Set File Search Path( {"C:/JMP/13/source", "C:/Program Files/SAS/JMPPRO/13/Samples"} );
Set Path Variable("name", <value>)
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.
dt = TripleS Import( "C:/Data/airlines.sss", Invisible, Use Labels for Imported Column Names( 0 ) );

Help created on 9/19/2017