Custom

The Parse Pattern property specifies the regular expression that determines which input values are considered valid.

• Only values that match this pattern will be accepted.
• You can define named groups (e.g., (?<GroupName>...)) to extract specific parts of the input for use in the 'Custom Format' property.
• Use standard .NET regular expression syntax.

> [!TIP] > Write patterns that match the full expected input. For more information, see the .NET documentation on regular expressions.

A combination of the following flags:

The Options property controls how the parse pattern is applied to input values.

• Common options include IgnoreCase (case-insensitive matching) and Multiline (treats input as multiple lines).
• Adjust these settings to match your data source and parsing requirements.

> [!NOTE] > Changing options can affect which values are considered valid matches.

The Custom Format property specifies how to construct the output value using the named groups captured by the parse pattern.

• Use curly braces to reference group names, e.g., {GroupName}.
• If left blank, the original input value is used as output.

Sample Formatting Scenarios

> [!TIP] > Use named groups in your parse pattern to enable flexible output formatting.

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.