topic Re: read a CSV structure in Application Development and Automation Discussions

read a CSV structure

Former Member — Tue, 23 Feb 2010 01:41:16 GMT

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.

Re: read a CSV structure

Former Member — Tue, 23 Feb 2010 01:51:28 GMT

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

Re: read a CSV structure

venkat_o — Tue, 23 Feb 2010 02:34:52 GMT

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

Re: read a CSV structure

Former Member — Tue, 23 Feb 2010 04:19:30 GMT

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

Re: read a CSV structure

Former Member — Tue, 23 Feb 2010 05:06:52 GMT

Hi,

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

Then read the file as usual with GUI_UPLOAD.

Thanks,

Sudheer