read a CSV structure

[Former Member]

Hi,

I have my data in internal table which has one filed, say fielda(2000) type c.

Now in this field i have data in CSV format.

e.g

abc, 101022, xyz, USA, 36598, etc

I have one final internal table in which I want to transfer this CSV values. Lets suppose final internal table name is final_itab.

Now i want to pass the values like this,

final_itab-f1 = abc

final_itab-f2 = 101022

final_itab-f3 = xyz

like this.

So in short i want to transfer CSV values to my final_itab. How can i do that.(each comma is one field).

Is there any function module for this.

[Former Member]

use FM, KCD_CSV_FILE_TO_INTERN_CONVERT to get the CSV data to Intenal table.

[venkat_o]

Hello, <li>Try this way.

LOOP AT it_csv_data.
  SPLIT it_csv_data-fielda AT ',' INTO it_final_tab-f1
                                       it_final_tab-f2
                                       it_final_tab-f3
                                       it_final_tab-f4.
  APPEND it_final_tab.
  CLEAR  it_final_tab.
ENDLOOP.

Thanks Venkat.O

[Former Member]

You can use Split statement if you know how many commas will be present in one particular line of CSV Format.

Hope this helps!!

Kanchan

[Former Member]

Hi,

Replace all commas with space using the comand REPLACE ALL OCCURANCES.

Then read the file as usual with GUI_UPLOAD.

Thanks,

Sudheer