You are here: Field Modifiers > Picture

Picture

Picture is a field modifier that specifies how to format a date field or numeric field. Picture can be used in command mode only. For a dialog equivalent, see Numeric Fields and Date and Time Fields.

Command Mode Syntax

Picture is abbreviated to “PIC”.

PIC "Format"

For example, the following command causes an output file, Negfile, to be produced:

EXTRACT Value PIC "$9,999,999.99" IF Value < 0 TO "Negfile"

In Negfile, amounts in the Value field are displayed with a leading dollar sign, separator commas and a decimal point.