'Records are not ingesting correctly through MLCP when special characters find in the csv

I am ingesting data to MarkLogic using MLCP, but many records got skipped due to invalid characters in the file.

Is there any way to ignore the invalid characters and ingest all records present in the CSV without skipping records?

Below is the error message in the logs:

WARN Skipped record: abc.csv at line 1414, reason: invalid char between encapsulated token and delimiter

marklogic mlcp

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source