Skip to Content
0
Former Member
Apr 01, 2009 at 07:48 AM

CSV file Format Error

106 Views

Hi All,

I'm down loading text file data to CSV format,it's downloading to CSV As each field is not separating the output is comming like:

01;OPA01/2009;063840045;P;20090122;1;2009;2000.00;AV00612/ADVANCE;;4000145004501/20

the CSV file has to be :

01 | PA01/2009 | 063840045 | P | 2009122 |.

I followed the logic is:

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

i_field_seperator = '|'

TABLES

i_tab_sap_data = itab

CHANGING

i_tab_converted_data = itab1

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc NE 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Please help one this..

Thank you..

Srii...