Reading a CSV file from server

[Former Member]

Hi All,

I am reading a CSV file from server and my internal table has only one field with lenght 200. In the input CSV file there are more than one column and while splitting the file my internal table should have same number of rows as columns of the input record.

But when i do that the last field in the internal table is appened with #.

Can somebody tell me the solution for this.

U can see the my code below.

data: begin of itab_infile occurs 0,

input(3000),

end of itab_infile.

data: begin of itab_rec occurs 0,

record(200),

end of itab_rec.

data: c_comma(1) value ',',

open dataset f_name1 for input in text mode encoding default.

if sy-subrc <> 0.

write: /, 'FILE NOT FOUND'.

exit.

endif.

do

read dataset p_ipath into waf_infile.

split itab_infile-input at c_sep into table itab_rec.

enddo.

Thanks in advance.

Sunil

[Former Member]

Sunil,

You go not mention the platform on which the CSV file was created and the platform on which it is read.

A common problem with CSV files created on MS/Windows platforms and read on unix is the end-of-record (EOR) characters.

MS/Windows usings <CR><LF> as the EOR

Unix using either <CR> or <LF>

If on unix open the file using vi in a telnet session to confirm the EOR type.

The fix options.

1) Before opening the opening the file in your ABAP program run the unix command dos2unix.

2) Transfer the file from the MS/Windows platform to unix using FTP using ascii not bin. This does the dos2unix conversion on the fly.

3) Install SAMBA and share the load directory to the windows platforms. SAMBA also handles the dos2unix and unix2dos conversions on the fly.

Hope this helps

David Cooper

[andreas_mann3]

Hi,

use translate command :

 CALL FUNCTION 'RFC_SYSTEM_INFO' 
    IMPORTING
      RFCSI_EXPORT             = RFCSI.

 translate waf_infile to code page  rfcsi-RFCCHARTYP.

Andreas