The
Parse a Column
process is a
JMP Scripting Language
(JSL) script that separates elements from a single text column into multiple columns, based on specified delimiters. It can be useful for processing columns with composite data from experimental design files or annotation files.
The file containing the column to parse must be
open
and
in focus
before you open the
Parse a Column
process. The
exp_design_1.sas7bdat
data set (found in the
SampleData\Microarray\Affymetrix Lung Cancer
directory), is used as an example, and is shown below.
The
exp_design_1.sas7bdat
data set is an example of an
Experimental Design Data Set (EDDS)
.Two values, one from the
Treatment
column and one from the
Array
column, have been appended to generate the unique values in the
ColumnName
column. The individual parts of the appended
variable
are delimited by an
underscore
(
_
).
For detailed information about the files and data sets used or created by JMP Life Sciences software, see
Files and Data Sets
.
Refer to the
Parse a Column
output documentation for a detailed description of the output of this process.