Posted by Bob A on April 05, 2012 at 08:44:57:
In Reply to: Re: difference in processing between .CSV and .txt posted by Barbara Brazil on April 05, 2012 at 08:17:20:
BB:
downloaded files from PROD system (where the FTP goes) to the TEST system using Windows Explorer
then.. had this strange thing where the record counts indicated that my program was reading the delimited file row-by-row, but when I dumped the input data as it was going by in the input routine (alas, not with TRACE, but the "hard way") came up blank every time
then, as a test I re-ran with a test file created a month ago... worked fine
so.... used UE to copy the file and save with another name (this time .csv).... worked like a charm
btw.... I read the files using plain old ACCESS nothing unusual there.... also, since this is coming from a non-windows ORACLE system, I checked all the bases I could think of:
made sure the line terminators were As I said before... since the program wasn't changed, the only thing I could think of was that something strange (never to be replicated) had happened... and when I re-created the file, all the errors went away. that the only difference between the QDIR.DIR entries was byte 23/24 and this was a date is as it should be.... Thanx Bob "A"
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.
made sure the encoding scheme was the same as the last file that worked
double checked I had properly changed the