Refer to your FOCUS documentation for complete information on using the commands below.
|
Decode
|
DEFINE FILE filename ADD
name/format = DECODE fieldname
(value newvalue
value newvalue);
END
|
|
Arithmetic
|
DEFINE FILE filename ADD
name/format = arithmetic expression;
END
|
|
Edit
|
DEFINE FILE filename ADD
name/format = EDIT (fieldname);
name/format = EDIT (fieldname,'masking');
END
|
|
Concatenation
(Weak Concatenation)
(Strong Concatenation)
(Concatenation w/blank)
|
DEFINE FILE filename ADD
name/format = fieldname|fieldname;
name/format = fieldname||fieldname;
name/format = fieldname||(' '|fieldname);
END
|
|
Logical
(Single IF Statement)
|
DEFINE FILE filename ADD
name/format =
IF fieldname logical operand value/fieldname
THEN value/fieldname
ELSE value/fieldname;
END
|
|
Logical
(Multiple IF Statements)
|
DEFINE FILE filename ADD
name/format =
IF fieldname logical operand value/fieldname
THEN value/fieldname
ELSE
IF fieldname logical operand value/fieldname
THEN value/fieldname
ELSE value/fieldname;
END
|
|
Date Expression
|
DEFINE FILE filename ADD
name/dateformat = date;
END
Date Format Examples:
Format YYMD will display as: 1968/01/01
Format MY will display as: 01/68
Format MTDYY will display as: JAN 01, 1968
Format M-D-Y will display as: 01-01-68
|
Last Updated: February 1, 2000