Error "Imported data is not in the specified format" when using pipe (|) as the delimiter

Cause

The Delimiter field within the File Format wizard can contain a regular expression. This is a special type of notation for expressing patterns using wildcards. In regular expressions the pipe (|) character represents a logical OR.

For example, if you had two files with the same field layout but one was delimited by a comma and the other a semi-colon, you would use a regular expression to define one file format to import both files by specifying a delimiter of ,|;

Resolution

To use | (pipe) as a delimiter, enter an escape character before the pipe.
This shows that the subsequent character should be interpreted as a literal character and not part of a regular expression. The escape character is the backslash.

Therefore to use the pipe character as a delimiter, set the delimiter field to:

 \|

Applies to

• Experian Payments Gateway - Experian Payments UK Gateway