Skip to Content
0
Former Member
May 13, 2008 at 09:02 AM

CSV separated by ";" to internal table

142 Views

Hello,

I've read a CSV into text internal table like that:

data: begin of it_text occurs 0,
           text(1024) type c,
         end of it_text.

But I need the data in another internal table with my fields like that:

data: begin of it_mats occurs 0,
          matnr type matnr,
          maktx type maktx,
        end of it_mats.

I can't use gui_upload to read the file because I'm reading the CSV file through FTP and not from a PC.

My question is, is there any Function Module to fill my it_mats table with the data of it_text table?

The data of the it_texts looks like that:

[1] 34;Description of material 34

[2] 35;Description of material 35

And I need the output like that:

[1] MATNR = 34 | MAKTX = Description of material 34

[2] MATNR = 35 | MAKTX = Description of material 35

Edited by: Marshal Oliveras on May 13, 2008 11:04 AM