topic Re: CSV file not produced with comma. in Application Development and Automation Discussions

CSV file not produced with comma.

anupam_srivastava2 — Tue, 21 Apr 2009 13:28:00 GMT

Hi All

I am using function SAP_CONVERT_TO_CSV_FORMAT to convert it into csv format.

but the file produced is with ;

I have put the

EXPORTING

I_FIELD_SEPERATOR = ','

but eventhough it produces with ;.

any help will be highly app

Re: CSV file not produced with comma.

Former Member — Tue, 21 Apr 2009 13:32:03 GMT

Can you post the code.

Re: CSV file not produced with comma.

Former Member — Tue, 21 Apr 2009 13:32:19 GMT

Use the FM SAP_CONVERT_TO_TEX_FORMAT instead.

Re: CSV file not produced with comma.

Former Member — Tue, 21 Apr 2009 13:33:53 GMT

Hi,

Use this


DATA: L_FIELD_SEPERATOR.
  L_FIELD_SEPERATOR = cl_abap_char_utilities=>horizontal_tab.

  CALL FUNCTION 'SAP_CONVERT_TO_TEX_FORMAT'
    EXPORTING
      I_FIELD_SEPERATOR    = L_FIELD_SEPERATOR
      I_LINE_HEADER        = I_LINE_HEADER
      I_FILENAME           = I_FILENAME
    TABLES
      I_TAB_SAP_DATA       = I_TAB_SAP_DATA
    CHANGING
      I_TAB_CONVERTED_DATA = I_TAB_CONVERTED_DATA
    EXCEPTIONS
      CONVERSION_FAILED    = C_RC4.

Re: CSV file not produced with comma.

anupam_srivastava2 — Tue, 28 Apr 2009 13:50:52 GMT

thanks