String

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.

The Maximum Length property controls the maximum number of characters permitted for a string value.

• Set to 0 to allow unlimited length.
• If a value exceeds this limit, it will be truncated or rejected, depending on the context.