Separator problem in CSV file download

Former Member · ‎2009 Oct 23

Hi All,

I am downloading the internal table data in CSV file format using the function modules SAP_CONVERT_TO_CSV_FORMAT and GUI_DOWNLOAD.

In the FM SAP_CONVERT_TO_CSV_FORMAT the default value for field separator is ;. But I want comma.

I am passing comma as a field separator but I am getting ; in my CSV file.

Please help.

Thanks in Advance.

- Neha.

Former Member · ‎2009 Oct 23

I think Changing I_FIELD_SEPERATOR = ';' to I_FIELD_SEPERATOR = ',' should work.

852

Former Member · ‎2009 Oct 23

Problem is solved. I am using the FM SAP_CONVERT_TO_TEX_FORMAT.

Thanks.

Edited by: neha1009 on Oct 23, 2009 11:17 AM

Former Member · ‎2009 Oct 23

Hi

It seems fm SAP_CONVERT_TO_CSV_FORMAT doesn't use the parameter I_FIELD_SEPERATOR, but a the constant C_FIELD_SEPARATOR with value ;

So u should replace ; with comma after calling that fm or check a SAP note

Max