How to Resolve File Format or Unexpected Character Errors

Issue

Syncs fail with one of the following error messages:

• Error Unexpected character ('X' (code 72)): Expected separator ('""' (code 34)) or end-of-line at line: ?, column: ?.
• Fix File Format
• Too many entries: expected at most 1 (value \#1 (? chars)

Environment

File connectors

Resolution

To resolve this issue, do the following:

1. Verify in the source document that double quotes are correctly escaped as specified in the RFC 4180 standard.
2. In the connector's Setup tab, click Edit connection details.
3. Set the Enable Advanced Options toggle to ON.
4. Specify a Delimiter in the connector settings.
5. (If needed) Specify an Escape Character.

Cause

The file appears correctly formatted and is ingested or parsed correctly by other tools or software. Different tools use different rules and libraries to parse CSV. The tool we use ingests CSV files that follow the RFC 4180 standard.

A common error, in this case, is having double quotes inside a field that also contains other characters, such as a JSON string.