topic FTP'd file in Application Development and Automation Discussions

FTP'd file

Former Member — Fri, 28 May 2010 01:58:50 GMT

Hi,

We have an interfacing system that dumps files to one of our directories. In Dev and QA server, the lines in every files in that directory always end with a pound (#) sign character. However, in production the lines do not end with a pound sign. Anyone knows what's causing this problem?

Re: FTP'd file

gerd_rother — Fri, 28 May 2010 05:44:29 GMT

Hi,

What do you use to view the file? The SAPGUI uses the #-sign to display all printable characters. Perhaps the sign you see is actually a line-feed (x0A) which concludes a line.

Regards, Gerd Rother

Re: FTP'd file

Former Member — Fri, 28 May 2010 05:57:56 GMT

I had come across similar situation. Our basis guys told me that since it is being FTPed from Unix to windows enviornment, the FTP program will put # at the end. Is your other system Unix? I changed my code by checking the last char in the record for #, if it found I deleted it. Hope this helps.

Re: FTP'd file

Former Member — Fri, 28 May 2010 06:20:51 GMT

Hi,

As already said, it is nothing but a line-feed. I have also faced such a situation. If you are reading that file using open dataset from any programs, the way I did is as follows

OPEN DATASET VA_FILE FOR INPUT IN TEXT MODE ENCODING DEFAULT WITH SMART LINEFEED

IGNORING CONVERSION ERRORS.

Thanks,

Sowmiya M