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","whateverwebsite.com/","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.

 

ADF.jpg

0 Replies