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...