Edit Mask - Infiniworx - Foundation 23.1 - Foundation 23.1 - AnyDoc - external

Infiniworx

Platform
AnyDoc
Product
Infiniworx
Release
Foundation 23.1
License

The edit mask rules options are:

Option

Description

Mask

Validates the data field against a predefined edit mask.

EnforcementFrequency

Specifies the frequency the rule will be enforced.

EnforcementLevel

Specifies the rule enforcement level.

Edit Masks are used to verify numeric data such as amounts, Social Security numbers, or phone numbers. Or to maintain consistently formatted data by validating the layout of the data.

To limit the data field to a specific format, build a custom edit mask using the characters listed below.

Character

Description

A

Any alpha character only

9

Any numeric character only

X

Any alphanumeric character

@

Variable number of alpha characters only

Z

Variable number of numeric characters only

*

Variable number of alphanumeric characters

$

Variable number of numeric characters only in an amount field (including commas)

V

Implied Decimal Point (inserts a decimal point)

.

Fixed Decimal Point

Certain characters have specific meanings in an edit mask. Any other character in the mask denotes a literal character and is output as typed.

Examples of Edit Masks:

  • Social Security Number:

    Expected output for a social security number = 114-26-7576

    Edit Mask = 999-99-9999

  • Amount Field:

    Expected output for an amount field = 123,123.00

    Edit Mask = $V99 or ZV99 or z^99

  • Account Number:

    Expected output for an account number = M537A264-22X

    Edit Mask = A999A999-99A

  • Letter/Number Combinations:

    Expected output = A31 or B2 or C127

    Edit Mask = AZ

  • Number/Letter Combinations:

    Expected output = 31A or 2B or 127C

    Edit Mask = ZA