Storage Type Numeric

Can be one of the following values:

The 'Processing Mode' determines which operations are performed on values:

• Format: Values are reformatted, but not filtered.
• Filter: Values are filtered, but not reformatted.
• Both: Values are both filtered and reformatted.
• Validate: Values are only validated.

Choose the mode that best fits your data extraction and validation requirements.

The Value Delimiter property enables a Data Field to store and process multiple values as an array, rather than a single value.

• When set, the field will accept and return multiple values, separated by the specified delimiter.
• Common delimiters include , (comma), ; (semicolon), or custom strings such as | or ~~.
• Choose a delimiter that does not appear in your data values to avoid parsing errors.

Usage

• To allow a field to store multiple entries (such as a list of codes or dates), set the 'Value Delimiter' to the desired character or string.
• When the delimiter is set, the field is treated as an array, and parsing/formatting operations will split and join values using this delimiter.
• If left blank, the field will only accept a single value.

Example:
If the delimiter is ;, a value like A;B;C will be interpreted as three separate entries: A, B, and C.

A combination of the following flags:

The Numeric Input Styles property controls how numbers are interpreted when entered or extracted.

• Select one or more options to match the expected format of your input data.
• Common options include allowing thousands separators, decimal points, leading/trailing whitespace, currency symbols, and more.
• The default is to allow any standard numeric style (Any), which accepts most common number formats.

Usage

• Use this property to restrict or expand the types of numeric input that are considered valid.
• For example, to only allow plain integers with no formatting, select NumberStyles.Integer.
• To allow numbers with currency symbols and thousands separators, include NumberStyles.Currency and NumberStyles.AllowThousands.

For a full list of options, see the documentation for NumberStyles in .NET.

A combination of the following flags:

The NumberFormats enumeration specifies which alternate numeric representations are accepted as input for numeric fields.

Overview

• Use this enumeration to support input such as fractions, numbers written in words, roman numerals, or mathematical expressions.
• This is especially useful for data entry scenarios where users may provide values in non-standard formats, or when extracting data from documents that use diverse numeric representations.
• Combine multiple options as needed to match the expected input for your use case.

The Custom Input Format property allows you to define a regular expression for parsing custom numeric input patterns.

• The regular expression must define a group named Value, and may optionally define groups named Fraction and Sign.
• Use this property to support specialized input formats not covered by standard or alternate formats.
• The parsed value is constructed from the named groups and then converted to a numeric value.

Required Regex Groups

• Value: (required) The main numeric portion to parse.
• Fraction: (optional) Digits to the right of the decimal point.
• Sign: (optional) A single +, -, or space character.

How It Works

• If a Fraction group is present, the Value group is treated as the integer/whole part, and Fraction as the decimal part.
• If a Sign group is present, it is prepended to the value.
• The resulting string is parsed as a decimal number.

Sample Parsing Expressions

> [!NOTE] > The regular expression must match the entire input string for parsing to succeed.

The Input Cultures property specifies which cultures (locales) are considered when parsing numeric input values.

• Add one or more cultures to support parsing numbers in different regional formats (e.g., US English, French, German).
• Each culture determines how numbers are interpreted, including decimal separators, group separators, and digit symbols.
• The order of cultures determines the priority when attempting to parse input.

> [!TIP] > Use this property to ensure that input values are correctly interpreted regardless of their regional formatting.

The Format Specifier property controls how numeric values are formatted for display and output.

• Enter a standard or custom numeric format string, as supported by .NET.
• Use ! to disable normalization and display the raw value.
• If left blank, default formatting is applied.

Usage

• Use standard format strings (e.g., n2, c, p) for common numeric representations.
• Use custom format strings (e.g., 00000.00) for specialized output.
• For a full list of options, see the documentation for Standard Numeric Format Strings and Custom Numeric Format Strings.

Formatting Examples

> [!NOTE] > The actual output depends on the current culture settings.

For more information, see the .NET documentation for numeric format strings.

Can be one of the following types:

The Output Culture property determines how numeric values are formatted for display and output.

• Select a culture to control the formatting of numbers, including decimal and group separators, currency symbols, and digit grouping.
• If not set, the document's culture or the system default will be used.

> [!NOTE] > This property affects only the display and output formatting, not the parsing of input values.

The Minimum Value property sets the lowest numeric value that is considered valid for this field.

• Enter a value to restrict input and output to numbers greater than or equal to this minimum.
• Leave blank to use the absolute minimum for the underlying Storage Type.
• Values below this threshold will be rejected during validation.
• Use this property to enforce business rules or data integrity constraints for numeric fields.

The Maximum Value property sets the highest numeric value that is considered valid for this field.

• Enter a value to restrict input and output to numbers less than or equal to this maximum.
• Leave blank to use the absolute maximum for the underlying Storage Type.
• Values above this threshold will be rejected during validation.
• Use this property to prevent out-of-range or invalid data entry.

The Value Range property displays the absolute minimum and maximum values supported by this Storage Type.

• This is a read-only property for informational purposes.
• The displayed range reflects the full range of the underlying numeric type, regardless of any user-specified minimum or maximum.