Escape character as the last character in CSV file

Copper Contributor

We're pulling data from a database and writing to a CSV file which then gets ingested into another database. We're wrapping our values in quotes and using a slash as the escape character. The issue we have is when the escape character occurs as the last character in the data ("Value 1","","Value3") it throws off our data load. This process is used for hundreds of tables with thousands of columns so using a backslash or double quote as the escape character ends in the same result. Does anyone know of a clean way to handle this in ADF? I can modify the source query to replace the value but that comes with a performance hit.



0 Replies