Picture Clause Expressions
Picture Clause Expression formats the way data is
stored into a selected index field in the Scanning Module.
The formatting is performed at two levels:
General Formatting Code applies to the
entire field. For example, you may select an option to format the
field to accept only capital letters.
Specific Data Entry is limited on a
character-by-character basis to a specified value. For example, an
index field can be formatted to accept only social security
When a Picture Clause Expression is used, the data
input operator cannot enter anything that does not conform to the
Selecting a Picture Clause for a Field
1. Start the Index Field
Editor for the selected database.
2. Click the [Picture Clause Expression]
Fields: – This list displays how the field
value will be formatted. After entering all selections, this field
displays the field format template.
Character Formatting Codes – This section
displays the options available for data entry. These are the
available formatting codes for specific formatting. For example, if
Social Security numbers are to be entered, type 999-99-9999 in the
text field. This would allow only Social Security numbers to be
Global Character Field Conditions – These
are the general formatting codes that apply to this field. For
example, if you select Convert All Lowercase Characters To
Uppercase, any letter typed in this field will be converted to
The previous descriptions for character fields
apply to Field Format and Character Formatting Codes
in this dialog box.
The Global Character Field Conditions
contain general formatting codes that apply only to numeric
For date fields, the following dialog box
Enter your desired selections in the appropriate
Picture Clause Editor dialog box.
Click [OK] to save the settings.
Image-Master returns to the Index Field
NOTE: In all cases a Picture Clause can be used to further
restrict the values stored in the created field
This legend shows which values the user can input
onto the Picture Clause Expression field that will convert
data to any format of their choosing. For example, entering
999-999-9999 establishes that the data will be in the form of a
A = Alpha Only
9 = Number Only
L = Logical Only
Y = "Y" or "N" Only
N = Letter or Number Only
# = Number, Blank, Sign
! = Upper Case if Letter
X = Any Character
Validate Character Date Format
This validation clause that takes an 8-character
string and determines if it represents a valid date given the
specific format of YYYYMMDD where:
YYYY=Year (rng 1000-3000)
MM= Month (rng 1-12)
DD= Day (rng 1-31, 1-30, 1-29, 1-28 based on month &
It returns True=valid date or False
Deploy "F:\EIDMS\Validation Modules7\ISADate.FXP"
to network IMASTER folder.
Configure source field (Default Value) to be
SPACE(8) and in Picture clause 99999999 (to enforce
numbers and max length).
In validation / Field Level Event Expression, enter
ISADATE(m1fieldname) where m1 is a literal and fieldname is
the actual name of the source field.