topic CSV file - Strings with multiple double quotes and commas in Application Development and Automation Discussions

CSV file - Strings with multiple double quotes and commas

SAPSeeker — Wed, 10 Feb 2016 20:11:33 GMT

Dear Guru's,

I am trying to write data from an internal table into a CSV file, but some fields has multiple commas (,) and double quotes (") within it. I tried covering the whole string within double quotes ("), but since the string has multiple double quotes and commas, the output in the file is not aligned. Can someone guide me how to overcome this issue ?

I don't want to have Horizontal tab as delimiter, since this is .CVS file and not .XLS file.

Thanks and Regards,

Gaurav.

Re: CSV file - Strings with multiple double quotes and commas

former_member183045 — Wed, 10 Feb 2016 20:45:54 GMT

I suggest you generate it with ;

(Semicolon).

Additionalally you can use the following function module.

SAP_CONVERT_TO_CSV_FORMAT

Regards, Andreas

Re: CSV file - Strings with multiple double quotes and commas

SAPSeeker — Wed, 10 Feb 2016 21:25:18 GMT

Got the issue resolved.

Followed the format of adding double quotes before existing ones and also covering the entire string within double quotes, as mentioned in the below RFC.

RFC 4180 - Common Format and MIME Type for Comma-Separated Values (CSV) Files

Best Regards,

Gaurav.