Skip to Content
0
Former Member
Jun 22, 2007 at 08:21 AM

CSV file read

17 Views

Experts

Hopefully you can help me.

I am reading a flat file using GUI_UPLOAD, splitting the file, then using another function module to load the data. The data is loading succesfully. However, all of the lines are loading under one header record. An example of the file format is :

Header bud cat doctype version fm area docstate process fund fund center cmmt item

H 9F 2 ZBW 9000 1 ENTR DEF A00 RM09

L 9F 2 ZBW 9000 1 ENTR DEF A00 RM09

H 9F 2 ZBW 9000 1 ENTR DEF A00 RM09

L 9F 2 ZBW 9000 1 ENTR DEF A00 RM09

I need to read the file, create the header record then create a line record (denoted by L). When the a new header record is found (H) create a new header and add the lines). At the moment its creating all the lines under one header.

thank you for your help