Multi-value separators

Use the Multi-value separator setting on the General Settings tab to enter only valid printable ASCII characters. This setting cannot contain the following characters:

  • Carriage return

  • Escape

  • New line

  • Space

  • Tab

You can enter additional delimiters between the values to indicate blank or NULL values.

Example:

bowling;fishing;;golfing;;;racing;swimming

The blank or NULL value is converted to an empty string during the export process. However, the following data types do not accept empty strings:

  • Boolean

  • DateTime

  • Float

  • ID

  • Integer

The document is rejected and the batch is routed to the Kofax Capture Quality Control module. If you have Kofax Express, the document fails to be exported.

The Multi-value separator should not be part of your value. For example, if you specify a period (.) as one of your values and you specify the period as the Multi-value separator, the export connector assumes the value is the separator. In addition, if you use the Multi-value separator for a single-value property, the literal string is used.