Escape Double Quotes when writing to CSV

Happy 2026 Guys

I am reading from SQL table where items are read properly in AETL
 

My second action is simply using transformation to write the same to CSV , I use Double Quotes as text qualifier , UTF-8 , Delimited . The expected output should be the 'escape' the double quotes, single quotes  if any found inside any column.

Currently I am able to solve this issue by doing a python calculation or by changing the same in input query but a default option would be appreciated. 

 

 

Upon Re-reading my input , I thought we need to input comma as well

Let me do some digging on it. I remember looking at iy a very long time ago and I am not sure what is a correct way of dealing with this kind of problems

Hi,
 

This is how it's to be stored in a CSV to get above output

"Work","Size","Time"
"ABC","4"",34""","ABCD"
"EFG","2""","EFG"
"JKL","2"" , 3"" , 45""","KLM"
 

FYI: We are still looking at it plus one of our customers reported similar issue

www.etl-tools.com/forum/advanced-etl-pro...sv-text-exports.html
 

Can you try latest version and let us know if it helps or not