importing data into dynamic temp table

S

shafee212

Member
i have imported data from a cvs file into a dynamic temp table by this piece of code

INPUT FROM value(m_inputfile).
repeat :
IMPORT UNFORMATTED m_inputfields .
buf:BUFFER-CREATE().
DO iTmp = 1 TO num-entries(m_inputfields):

buf:BUFFER-FIELD(iTmp):BUFFER-VALUE = entry(iTmp,m_inputfields,",").
END.
END.

The problem here is that I don't want to import the top 4 line of csv file as they are lables .What i have done in my code is that i have assigned labels of 1st line as field names of dynamic temp table . And the rest 3 lines of csv are also labels which should not come into the temp -table .

Can any one help me out .
 
Code: 
INPUT FROM value(m_inputfile).
[b]IMPORT UNFORMATTED ^.
IMPORT UNFORMATTED ^.
IMPORT UNFORMATTED ^.
IMPORT UNFORMATTED ^.[/B]
repeat :
        IMPORT UNFORMATTED m_inputfields .
        buf:BUFFER-CREATE().
        DO iTmp = 1 TO num-entries(m_inputfields):
           
            buf:BUFFER-FIELD(iTmp):BUFFER-VALUE = entry(iTmp,m_inputfields,",").
        END.
 END.
 
You must log in or register to reply here.
Back
Top