We are transferring files from a new ftp server hosted on a unix/linux
The transfer is using ascii mode
If you look at the ascii file there are CRLF (0A0D) at the end of each
After ftp'ing the file directly to a physical file we have a end of line
character of hex 0D
Here is an example
Our process to then read the file wich is in csv format was then failing
on the end of line character.
We have added some code to replace the hex 0D with a blank and this has
enabled the file to be processed but I have not been able to find any
So just asking the group if someone has hit this issue before and how they
resolved the problem
With files that we ftp from a windows server there is no end of line
character at all as per the following example
Pay Period,,2302,,Account Number ,,4770,,,,,,,,,,
Any suggestions welcomed
This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.