Skip to Content
4
Former Member
Jul 18, 2007 at 06:25 PM

MOVE THE SECOND FIELD VALUES

21 Views

hi guys,

I am uploading the data for open AR items from an PIPE delimiter file. I read the data into an internal table and spilit the data at pipe delimiter.... now I have to do some validations.

There is one trailer record at the end in the file. In that trailer record I get the number of records in the second field like

9|20|100.000|10.000| here 20 is the number of records

if it is a standard structure file then i can write the logic as

IF V_FNAME1 NE 'X'.

DESCRIBE TABLE I_FILEDATA1 LINES V_FILEDATA1.

READ TABLE I_FILEDATA1 INTO WA_FILEDATA1 INDEX V_FILEDATA1 .

MOVE WA_FILEDATA1+2(5) TO V_LINES1 .

IF V_FILEDATA1 NE V_LINES1.

MESSAGE 'NUMBER OF LINES READ ARE NOT SAME' TYPE 'E'.

ENDIF.

ENDIF.

In the above logic i counted the number of records and compared that number with the number of records given in the trailer record (20)

how to modify this logic if the file is a pipe delimiter file.....

how to capture that value into one variable can any one guide me please......

SRI