READ DELIMITER (SET)

READ DELIMITER (SET)

Subcommand under SET

Specifies the character that is used as the delimiter to separate data fields in an ASCII data file.

If Excel writes a comma delimited ASCII file (.CSV), then missing values are denoted with ",,". In order to interpert these files correctly, you can enter the command
SET READ DELIMITER <value>

with <value> denoting the desired delimiter. The default delimiter is a comma.

If Dataplot encounters the delimiter before any valid data has been found, it interprets this as a missing value.

By default, missing values are set to 0. If you would like to specify a different value to use for missing values, enter the command

SET READ MISSING VALUE <value>

SET READ DELIMITER <value>
where <value> denotes the value to use as the delimiter.

SET READ DELIMITER :
SET READ DELIMITER ,
SET READ DELIMITER %

Comma

None

READ	= Carries out a column-wise input of data.
READ MISSING VALUE	= Specify the value to use for missing data.

Input/Output

2004/01

 
SET READ DELIMITER  ,
SET MISSING VALUE -99
READ DUMMY.CSV  Y X
PLOT Y X   SUBSET Y > -99 SUBSET X > -99