# System and Global Edits List

The following is a list of filePro defined GLOBAL edits.

Edit | Description
* | Accepts any value.
# | Accepts only 0-9, periods, dashes, slashes and blanks; right-justify; (will not sort in numeric order).
$ | Prepends a dollar sign; accept any number of digits and a negative sign in front of the point; show point and two decimal places, right-justify the result; (since it truncates rather than rounds, use only for result fields),n (where n = 0-8 or F); add a comma every 3 digits.
.0 | shows integer values only; no decimals.
.n | (where n = 0-8); accept numeric; show n decimal places.
A | accept A-Z, a-z
ALLUP | accept words (usually names) in upper or lowercase, convert contents to uppercase
ALNUM | alphanumeric; restricted to A-Z, a-z, 0-9, and blanks
ASCII | accept the entire range of printable characters
CHEQUE | convert dollar amounts to words (used for printing checks); suggested length is 75
DMY | DDMMYY format; (6)
DMY/ | DD/MM/YY format; (8)
DMYY | DDMMYYYY format; (8)
DMYY/ | DD/MM/YYYY format; (10)
F | floating decimal
HM | HH:MM; minimum length of 5 for minutes + n for hours > 99
HMS | HH:MM:SS; minimum length of 8 for minutes + n for hours
LOWUP | change leading letters to caps; leave other caps intact
MDY | MMDDYY format; (6)
MDY/ | MM/DD/YY format; (8)
MDYY | MMDDYYYY format; (8)
MDYY/ | MM/DD/YYYY format; (10)
MMM_YY | convert a MDY, MDYY, MDY/, MDYY/ date into MON/YEAR
N | accept 0-9 only
NUM | accept 0-9, supplies a zero if position is left blank
PARNEG | remove minus sign from a negative number and place parentheses around the number
PHONE | the entire number in phone number format; (to include area codes,
RJ | right-justify
RMINUS | move minus sign of negative number to the right side of number
SEX | accept only M, F, m, or f, and change lower to uppercase; (use a length of 1)
SSNUM | Social Security number; accept 0-9; show dashes;(len must be 11)
STATE | accept standard postal abbreviation; (length must be 2)
UNPAREN | Removes parentheses
UNPHONE | remove parentheses, hyphens, and spaces from phone # string
UPLOW | change leading letters to caps, all others lowercase, except Roman numerals & De, Del, La, Li, Lo, Mac, Mc, and San
TIME | HH:MM:SS; length of 8; accepts 00:00:00-23:59:59
YESNO | (use a length of 1)
YMD | YYMMDD format; (6)
YMD/ | YY/MM/DD format; (8)
YYMD | YYYYMMDD format; (8)
YYMD/ | YYYY/MM/DD format; (10)
ZIP | Accepts 5 or 9 digits with or without dash; show dash in 9-digit zip; (length must be 5 or 10)
0RJ | Right-justify and "0" fill