We have a need to clean up CSV files and produce comma delimited files (not tab delimited). If the data has commas embedded in the fields, those fields should be quoted.
Currently it's possible to set the tsv-delimiter to comma, but this would also replace any commas in the source data with spaces, which is not what we want.
The goal of this exercise is to basically go from QUOTE_ALL to QUOTE_MINIMAL for the CSV files.
We have a need to clean up CSV files and produce comma delimited files (not tab delimited). If the data has commas embedded in the fields, those fields should be quoted.
Currently it's possible to set the tsv-delimiter to comma, but this would also replace any commas in the source data with spaces, which is not what we want.
The goal of this exercise is to basically go from QUOTE_ALL to QUOTE_MINIMAL for the CSV files.