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'.
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......